Jolibet legit or not,Bouncing balls simulation.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved macek03
(@macek03)

5 years, 6 months ago

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)

5 years, 6 months ago

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)

5 years, 6 months ago

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)

5 years, 6 months ago

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)

5 years, 5 months ago

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)

5 years, 5 months ago

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.

Tags