Importing Multiple Suppliers

mattdbroderick

Hello. Thank you for your help in my other post. I have another question.

I'm building a site with nearly 5000 products so I'm relying heavily on the importer. Many of those products have multiple suppliers, this is what drove me to use ATUM's multi-inventory.

I've added the products with one inventory. How do I use the importer to add new inventories and suppliers to the existing products without having to go through them one by one?

Thank you

Salva

Hi mattdbroderick

I'm sorry but the only way to do it is with Excel, copying the correct inventories and pasting the rows for each product (and adjusting the product ID accordingly). I know this is going to be tedious for 5000 products but a lot better than setting up the products in WooCommerce one by one 🙂

Best Regards,
Salva.

mattdbroderick

Hi Salva.
I'm stuck on Product IDs. I thought we couldn't make our own IDs?
Could you give me an expanded explanation of how to do this with excel? I imagine you export with the ATUM Multi-inventory template > Copy and paste all products you wish to have a second inventory > add new supplier information from each > Import. It's just IDs that I'm stuck on.

Thanks!

Salva

Hi mattdbroderick

When you export using the Multi-Inventory template and you already have some inventories that you created manually as a base, you will see 2 distinct IDs on the exported CSV (the product ID and the Inventory ID).
If what you want is to create new inventories for the rest of the products, you just have to create new rows and to add their corresponding WooCommerce's product IDs to each one (so the ATUM Export can know to which product assign each of them) and leaving the inventory ID for these empty (as those inventories are still not available on WooCommerce and you are going to create them all as new ones).
Once you are done with all the products, I'd recommend you remove the ones that were already created manually from the CSV and leave the new ones only and when importing, you just have to select the INSERT option.

If you have further questions, just let me know, please 😉

Best Regards,
Salva.

mattdbroderick

Thank you Salva, we're getting closer.
I exported the multi-inventory, doubled the products, erased the Inventory ID and updated with new supplier information. Then I erased all but the new inventories and imported them as new.
It created secondary inventories for the products but did not fill in the supplier information. The supplier and supplier SKU are both blank.
I exported the multi-inventory again and took a look, the information is blank on the export as well.
I attempted to fill it in again and reupload but the same thing happened.

Any udea what might be causing this?

Thanks again

japiera

Hi mattdbroderick ,

My name is José Andrés, and my colleague Salva asked me to continue with this thread.

My apologies if there's anything I'm going to say next you were clear about, but this way I won't forget anything.

Suppliers need to be created (or imported) before you import inventories.
The Supplier field value must be the Supplier's ID.
If you imported the Suppliers with ATUM Export pro, you can use either ID, the new assigned when importing, or the old one you used in your import file.

After the importing process, although if it went well, there may have been some problems, you can see these possible errors for each inventory by hovering the result icon (as you can see in the last image on this post). If with the above instructions the Supplier is not yet properly imported, please, tell me if you get any message when hovering the result icon.

If you don't get any errors there, I'd need additional info (as the template you're using, the file you're trying to import, etc), and it's probably information you'd rather not share publicly, so I suggest you open a private ticket here

Hope this helps,
José Andrés

mattdbroderick

Thanks for getting back to me José, I'm going to open a private ticket and send a screencast.

AndreaRebel

Hi @mattdbroderick , okay!

AndreaRebel

Hi again @mattdbroderick ,

I think we didn't get your ticket in ticksy. Is that right? Did you solve the issue?

I will appreciate your feedback.

Best Regards,

Andrea.