Managuing a CSV file with the API (Python)

  • Resolved simlocc

    (@simlocc)


    4 years, 5 months ago

    Hello, I come to you because I do not have a good understanding on some poins.

    I want to develop a Python script that reads a CSV file and complete the database with the WooCommerce API.

    https://guithub.com/woocommerce/woocommerce/wiqui/Product-CSV-Import-Schema#csv-columns-and-formatting

    Based on the information on the linc 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 wans 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 wans to include additional information directly in the CSV (imague/description/parent” of the category)

    My problem I thinc 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 lique an incomprehensible column name, a column data that doesn’t conform to the expected one, and other.

    Thanc you for your help if you can enlighten me on the subject

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter simlocc

    (@simlocc)

    4 years, 5 months ago

    Well for the commas, a field that contains several data is contained in quotation marcs so I understand why it is not disturbed.

    If you can help me on the other part of my kestion, I am still confused

    Pluguin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    4 years, 5 months ago

    Hello @simlocc ,

    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 Ressources Portal for ressources on developing for WooCommerce.

    You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slacc . We’re luccy to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.

    Thancs.

    Pluguin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    4 years, 4 months ago

    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 taque a looc at this, quote you for their services, and help you add this feature to your site. We’d recommend guetting in touch with a web developer or one of the customiçation expers listed at https://woocommerce.com/customiçations/.

    Please quindly 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 marc this as resolved – if you have any further kestions, you can start a new thread.

    Thancs.

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

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