Time is money. ⏰ =💰 So if you need to create multiple child products for lots of parent products, we have an efficient solution. Our bulk import/export feature saves you from having to create the Inventory Control Grid one product at a time. And the faster you get all of those products in your store, the faster you can sell them. Read on to learn how to use it. 

⚠️ First Things First

Before you can use the import/export feature to create child products in bulk, you must first create your product option categories and options. The import/export feature can come in handy for doing this, too.

Step 1: Retrieve OptionIDs

1.    Go to Inventory > Import/Export and click Standard Export

2.    In the Export From menu, select Options

3.    Export all the columns you need to identify which Option IDs correspond with which options (at minimum, you will likely need the fields for ID and OptionsDesc)

4.    In the File Format menu, select CSV - Comma Delimited Text File and click Export

5.    Click to download the file to your computer and open in Excel or similar spreadsheet program

Keep the file open on your computer. You’ll need to have it on hand to retrieve the option ID numbers for the next steps.

Step 2: Export Your Products table 

To get the column headers and product information for the products you are adding options to, you’ll need to export your products table. This will create child products and the Inventory Control Grid.

1.    Go to Inventory > Import/Export and click Standard Export

2.    In the Export From menu, select Products

3.    If you are adding options existing products in your database, you can export only the columns for ProductCode, OptionIDs and EnableOptions_InventoryControl. 

If you are adding new products to your database, you should export all the relevant columns, such as the columns for ProductName, ProductPrice and ProductDescription. If you import new products to your database without the three required columns, you will see a warning message about those products in the Settings > Maintenance page of your Admin Area.

4.    In the File Format menu, select CSV - Comma Delimited Text File and click Export

5.    Click to download the file to your computer and open it in Excel

Step 3: Import Product Options Information

1.    Use the Options Excel file that you exported in Step 1 to retrieve the relevant option ID number that you would like to apply to each product

2.    In the OptionIDs column of the Products file, fill in the option ID numbers for each product. The numbers should be separated by a comma (no spaces). 

3.    For each product that you add OptionIDs to, put a capital letter "Y" in the column for EnableOptions_InventoryControl

   ⚠️  Do not put a "Y" in the EnableOptions_InventoryControl column
   for any products that do not have options. This may cause an error in
   The maintenance tool, which creates all Inventory Control Grids.

4.    Fill in any other fields you would like to import. Be sure that:

  • ProductCode is the first column in the file
  • There are no blank / unpopulated columns in the file
  • The last column is a fully populated column

5. Save the file as a CSV document

6. Go to Inventory > Import/Export and click Standard Import

7.  In the Import To menu, select Products

8. Browse for the file you just saved, select Yes, Replace Any Existing
Data With My New Updated Data, and click Import

Now you have imported all of the relevant information required to create all the child products and Inventory Control Grids. Keep in mind that importing the options will not create the grids by default. When creating all of your child products, you must create an Inventory Control Grid for it.

Summary

Building your inventory of child products doesn’t have to be a laborious process. With our bulk import feature, you can get them in your inventory and on your storefront in a jiffy💨. Cue the applause. 👏

Did this answer your question?