Add suppliers to products in an easy way?

mats

Hey, is there a way to add suppliers to products in an easy manner? At the moment it looks like I need to open the product page, navigate to the correct tab, search for a supplier (which works slowly) and finally update the product. This is an increadible amount of work.. I have over 2000 products in my store and doing it this way will take forever.

I thought you could at least add the supplier in stock central (as you can modify prices etc.) but apparently you can't do that but actually have to open the product page?

Forum_Admin

hi mats ,

Thank you very much for your post.

Hope my answer will be satisfactory.

Adding suppliers in bulk is not possible yet. However, you can do this by editing the database. Searching for supplier or better the speed of searching is not just ATUM, but several factors like server speed, WooCommerce speed or the size of your database for example. We were improving performance on daily basis, but for now I have turn my devs to other tasks as developing new features. WooCommerce is due to introduce new table system that should increase the speed massively. We will wait for this to be released to see what it does to the system.

You will be in deed able to add suppliers from SC in the future, but for now this is not an option unfortunately.

Hope this helps.

Pavel

nats

How would we mass update the database? I've searched through my database and it only seems like the _supplier meta-key is generated after a supplier is specified.

Forum_Admin

Hi nats

Thank you very much for your post.

A lot has changed since August in the ATUM code. What would you like to achieve?

FelipeNS

I need this too, how can I add mass update the product suppliers or the database?

japiera

Hi FelipeNS ,

We do not take any responsibility for the below action! Only for experienced users!

Please, remember to make a backup of your database before trying this!!!

As noted above you'll need advanced knowledge to understand the following.
1. Since ATUM version 1.5 and to follow the philosophy of WC, we moved all our metadata to a new table called [db_prefix]atum_product_data.
2. Suppliers are stored in the database as Posts (atum_supplier post type).
3. The product's supplier is stored in the "suplier_id" field from the Atum product table.

So, once you've figured out the supplier id for your products, you can generate and execute a SQL file with as lines as you need like:
UPDATE [db_prefix]atum_product_data SET supplier_id = [my_supplier_id] WHERE product_id = [my_product_id];

And I repeat again, please don't do this if you don't know what you're doing!!

Hope this helps.

Best Regards,
José Andrés

FelipeNS

I added one by one haha. By the way I always buy from Alibaba and multiple sellers sell the same product. So at least for me I don't see this necessity to choose a supplier, I just want to use the inbound system to see whats coming

Finnie

Hi. Trying ATUM and wondering has this been updated yet? Have 12K SKUS...

Thanks Finnie

Salva

Hi Finnie

Please read this:

https://stockmanagementlabs.crunch.help/en/atum-export-import-pro/how-to-add-suppliers-to-your-products-in-bulk

Best Regards,
Salva.