• Resolved macek03

    (@macek03)


    Hello guys!

    First of all, it’s my first post here and I am just starting my journey with WP and WooCommerce. I am setting up an E-commerce store for my friend which is based on WP. He want’s to do the dropshipping, which will import the products from a Brandsdistribution.com (magazine) to the WordPress E-commerce store. And while doing that I came across an issue with the different structure of the CSV files (generally both files are almost the same but some fields are not in WP schema, some are but not in order, and others have just different names) – what makes importing of the products a little bit difficult.

    While analyzing that I figured out that they are 2 solutions:

    1) Either I will edit the CSV file from Brandsdistribution every time exporting and importing stocks status of the items (which might be tedious task to do, while
    I will need to do that a couple of times during the day – ofc later I would like to automate the process so WP could check the stock quantity automatically every hour).

    2) Or I could just simply edit the code in WP so the structure of the WP schema will be the same as the structure of the Brandsdistribution CSV file. (which I don’t have clue how to do that for now).

    I came across this article, but don’t know exactly how to apply it (where to put the code):
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Importer-&-Exporter#adding-custom-import-columns-developers

    Any suggestions maybe?

    Thank you for your time and consideration in advance!

    Regards
    Maciej

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Stef

    (@serafinnyc)

    I would look at connecting the API from BD to WC first and test with one product import if at all possible. If that one product imports with all your meta needed you know you’ll be okay importing the entire deal in one shot.

    If not then I’d incorporate the git snippet and get the custom columns from BD added. You said you’d be adding two custom columns so you’ll add those two the snippet and then apply them in the backend when importing.

    However, I’d start with the API first. Reach out to BD and see if they can advise and then if you’re not comfortable with code then I’d look for a qualified developer to help.

    You can find approved WC devs here
    https://woocommerce.com/customizations

    Thread Starter macek03

    (@macek03)

    These are example of two imported CSV files:

    1) CSV from Brandsdistribution:
    https://ufile.io/sgmtrn5s
    2) CSV from WooCommerce (WP):
    https://ufile.io/yt39k0pm

    You can see there the difference of the structure file (column names, ordres)

    Stef

    (@serafinnyc)

    I know the structure very well. I helped create them. Again, I’d look at importing everything via API. That is if you have everything on BD already.

    Plugin Support EtienneP a11n

    (@etiennep)

    Hi @macek03

    In addition to what @serafinnyc mentioned, I see that there is a plugin available that would make the import of products from brandsdistribution.com to a WooCommerce site easier;

    https://shop.zero11.it/shop/wordpress-extension/wordpress-brands-sync/

    I also found a guide from brandsdistribution.com on how to get started with it – https://blog.brandsdistribution.com/2018/06/01/chapter-3-brandsdistribution-plugin/

    Plugin Support EtienneP a11n

    (@etiennep)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

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

The topic ‘CSV integration issue with Brandsdistribution – Adding Custom Import Columns’ is closed to new replies.