Managing a CSV file with the API (Python)

  • Resolved simlock

    (@simlock)


    3 years, 3 months ago

    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

    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

    (@simlock)

    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

    (@sohanhossain)

    Hello @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 for resources on developing for WooCommerce.

    You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce 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

    (@sohanhossain)

    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.