Loaded 7 Option Variants Import/Export Guide
Posted by on 11 March 2014 04:59 PM
Loaded 7 provides you with a powerful way to import and import Option Variants through a tab delimited CSV file.
You can also Import and Export Categories and Products. These will be covered in separate articles.
In this guide we will:
Step 1: Exporting Products or Sample File
To Export your Options Variants or sample file, login to your Administrative Tool and click Products
Then Click on Products Import/Export
If you would like to export Options Variants click the button denoted by the red arrow (Full Data Set)
To download a sample file, click the button denoted by the blue arrow (Get Sample File)
Remember your download location.
Step 2: Working with your data file
You can work with this file in any spreadsheet or notepad program. Spreadsheets are preferred as they have an easier view.
Open your spreadsheet program and open the file that you downloaded, you may see a few boxes as shown below.
Ensure Delimited is selected, Import is at column 1 and that the File origin is correct. Click Next
On the next box, ensure that Tab is selected and leave the text qualifier unchanged. Click Next.
In the final box, Make sure the Column data format is General and click Finish.
Now that our file is open, it will look like the image below, we are ready to edit Option Variants.
You will see a number of fields and they are explained below.
When you exit your spreadsheet program you may see this message, click save and choose the location in which you would like the file if it has changed.
Step 3: Importing your Changes
We are now ready to import your changes. Navigate to the Products Import/Export page.
You click on the Upload a File button.
Once you click, you will be presented with a file box. Navigate to the location of the file. Select the file and click open.
You will now see the file ready to be imported. To start the import, click Import.
After the import is completed, you will see the results. It will show you the number of items imported and the number updated. If you are adding new items as well, you would see the number added.
Adding New Items
You can add items in 2 ways. You can add them to your full product set data file, or start with an empty sample file. The sample file includes the required headers.
The biggest change when importing new items is that the id column MUST be blank.
Ensure that you fill in all information for the new items.
When you are done creating the file, the file and you are now ready to import.
Follow the same steps as above:
When finished, your dialogue box will look a bit different, you will see it will show you the number of new items imported.
You should now see your new options in your Admin Console and also when they are added to products.
If you do not see the new products or other changes reflected on your storefront, you will want to clear the store cache files. See the steps below.
1. There are 4 steps on this screen:
1. In the show box, select all