Empty row error
The "empty row" error isn't a true error. It simply means that when you imported your product list Venzee found one or more empty rows and ignored them.
Merged cells error
While Excel and other popular spreadsheet programs allow users to merge cells Venzee cannot import values from merged cells:
If your spreadsheet contains any merged cells the row containing the merged cells will be skipped and those products will not be imported.
The following information will help you find merged cells and un-merge them.
To find merged cells in Excel 2016 and 2013...
1. Click Home > Find & Select > Find
2. Click Options > Format
3. Select the Alignment tab and under Text control check the Merge cells box and click OK.
You have the option of clicking Find Next to find the next merged cell or clicking Find All to see all the merged cells in your spreadsheet.
Clicking an item in the list selects it in your spreadsheet.
To un-merge cells in Excel 2016 and 2013...
1. Select the cell that you want to unmerge.
2. Click Home > Merge and Center
The contents of the merged cell will be moved to the upper-left cell.
Missing product ID error
If your spreadsheet contains one or more missing product IDs the row(s) containing the missing product ID(s) will be skipped and those product(s) will not be imported.
To correct this add product IDs to those cells and try the import again.
How to find and highlight blank cells in Excel 2016 and 2013...
1. Select your data.
2. Go to Home > Conditional Formatting > New Rule
3. Select Format only cells that contain and set Format only cells with to Blanks and click OK.
Missing parent ID error
Variants without parent products will not be imported.
There are two solutions here:
Solution 1: Add the parent to the original spreadsheet by updating your products.
Note that this assumes you are adding variants via uploading another spreadsheet. If this is the case you will need to go back and update the original spreadsheet so that it includes the parent(s).
Solution 2: Add the parent(s) along with the variant(s) to the spreadsheet that you're using to add variants to your products. However, be sure to add the parent(s) before the variants in the spreadsheet.
In the example below Items 2 and 3 are variants of Item 1 and that Item 1 is listed in the spreadsheet before Items 2 and 3:
Duplicate product ID error
If one or more of your unique identifiers (product ID, SKU, Model number, ISBN, etc.) are duplicated the first product with the identifier will be imported but the second will not. For example, in the image below the SKU number "DH-00003" is duplicated. In this case, the Bluetooth Speaker will be imported but not the Portable DVD Player.
If this happens check for duplicates in your spreadsheet. You can easily do this using Excel. (The instructions here are for Excel 2016 and 2013.)
How to find duplicates in your spreadsheet...
1. Select the range of cells that you believe might contain duplicates.
2. From Excel's Home tab choose Conditional Formatting > Highlight Cells Rules > Duplicate Values:
3. Choose a formatting for your duplicate values and click OK.
4. Any duplicate values are now identified.