The potential of ATUM Export Pro allows you to export data, modify it in bulk, and later import it on your site or on a new site. Undoubtedly, this functionality will save you a lot of time and will help you optimize the stock management of your online store.
You can bulk-import any kind of data, and in this post we will explain to you how to bulk insert multi-inventories. Follow the next steps:
In order to keep it simple, In this case we are going to make an export of just a simple product with Multi-Inventory enabled.
First, go to Export Pro, and export from scratch or from a template. If you export from scratch you will need to choose the Multi-inventory entity. If you export from a template, the entity is already chosen
- From scratch
- From a template
Once exported, import the archive to Google Sheets.
Let’s see some points:
- The ID field is used to uniquely identify the inventory. Although it's mandatory to include it, it's not used when inserting (only would be used for reference purposes when migrating from one site to another), but you'll need this identifier when updating existing inventories data.
- Product_id is the unique product identifier.
- Is_main identifies where an inventory is the Main inventory or not. Only one Main inventory can be set per product.
Said this, now modify the data you want to use for creating the secondary inventory. In this case, we are going to modify the inventory’s name and the is_main field.
Export the spreadsheet as .csv format.
Import the created CSV file using ATUM Export with the default ATUM Multi-Inventory template or the custom one you’ve created. As always, before importing data make sure that you have a backup.
As you can see in the image, although the inventory id in the CSV file had the value '17', since I've chosen the INSERT option, a new inventory has been created with the id '18'.
The secondary inventory is already created:
If you want to insert a secondary inventory for each of your products, you can export all of them using the Multi-Inventory template, modify all the files according to the previous instructions, and import the result back to the site, or you can export only one, duplicate the line 200 times and edit each file and the proper product id and the is_main to '0'. Just choose the option that is easiest for you.