Title: Managing a CSV file with the API (Python)
Last modified: August 18, 2021

---

# Managing a CSV file with the API (Python)

 *  Resolved [simlock](https://wordpress.org/support/users/simlock/)
 * (@simlock)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/managing-a-csv-file-with-the-api-python/)
 * Hello, I come to you because I do not have a good understanding on some points.
 * I want to develop a Python script that reads a CSV file and complete the database
   with the WooCommerce API.
 * [https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting](https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting)
 * Based on the information on the link above, the data of the same field are separated
   by commas but a CSV already separates all these fields with commas so is it that
   for each CSV, the separator must be passed on a semi-colon?
    Yet it doesn’t seem
   to interfere?
 * Still based on the same site, what can we do if the customer wants to add more
   information on his CSV?
    For example, if I detect a category that does not exist
   in the database, then I will create it but if he wants to include additional 
   information directly in the CSV (image/description/parent” of the category)
 * My problem I think is that I can’t see how I can adapt to a lot of providers 
   with different columns or information that I can’t handle like an incomprehensible
   column name, a column data that doesn’t conform to the expected one, and other.
 * Thank you for your help if you can enlighten me on the subject

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [simlock](https://wordpress.org/support/users/simlock/)
 * (@simlock)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/managing-a-csv-file-with-the-api-python/#post-14784264)
 * Well for the commas, a field that contains several data is contained in quotation
   marks so I understand why it is not disturbed.
 * If you can help me on the other part of my question, I am still confused
 *  Plugin Support [Shohan Hossain Nabil – a11n](https://wordpress.org/support/users/sohanhossain/)
 * (@sohanhossain)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/managing-a-csv-file-with-the-api-python/#post-14784496)
 * Hello [@simlock](https://wordpress.org/support/users/simlock/),
 * This is a fairly complex development topic. I’m going to leave it open for a 
   bit to see if anyone is able to chime in to help you out.
 * I can also recommend [the WooCommerce Developer Resources Portal](https://developer.woocommerce.com/)
   for resources on developing for WooCommerce.
 * You can also visit the [WooCommerce Facebook group](https://www.facebook.com/groups/advanced.woocommerce/)
   or the `#developers` channel of the [WooCommerce Community Slack](https://woocommerce.com/community-slack/).
   We’re lucky to have a great community of open-source developers for WooCommerce,
   and many of our developers hang out there, as well.
 * Thanks.
 *  Plugin Support [Shohan Hossain Nabil – a11n](https://wordpress.org/support/users/sohanhossain/)
 * (@sohanhossain)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/managing-a-csv-file-with-the-api-python/#post-14816578)
 * Hi there,
 * There hasn’t been much activity on this thread, so I wanted to add a few more
   options for you.
 * if you do require more help with the actual coding, we’d recommend you hire a
   developer who can take a look at this, quote you for their services, and help
   you add this feature to your site. We’d recommend getting in touch with a web
   developer or one of the customization experts listed at https://woocommerce.com/
   customizations/.
 * Please kindly note that this requires some custom coding – which goes beyond 
   the scope of support we are able to provide in this forum.
 * I’m going to mark this as resolved – if you have any further questions, you can
   start a new thread.
 * Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Managing a CSV file with the API (Python)’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [api](https://wordpress.org/support/topic-tag/api/)
 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [python](https://wordpress.org/support/topic-tag/python/)

 * 3 replies
 * 2 participants
 * Last reply from: [Shohan Hossain Nabil – a11n](https://wordpress.org/support/users/sohanhossain/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/managing-a-csv-file-with-the-api-python/#post-14816578)
 * Status: resolved