Avoid Multiple SKUs for the Same Product
Using a CSV spreadsheet to upload your products into ShippingEasy is a quick way to update your catalog. Once you have imported products into ShippingEasy, subsequent spreadsheet uploads can be used to update stock levels and add new products, however, it can also create separate SKUs for one product if the spreadsheet is not formatted correctly.
Separate SKUs get created when the CSV spreadsheet has converted the existing SKU into an exponent. This happens if the SKU number extends past the range of the cell, creating a number such as 9.28375E+14.
To avoid this, you'll need to format the SKU column to prevent your spreadsheet from using decimals and additional characters before uploading products.
-
Open file in Google Sheets
-
Highlight the desired Column (SKU)
-
Select Format in the top menu
-
Mouse over Number- then in the side menu, select More Formats- Then select Custom number format.
-
Select the number format with no decimals or additional characters. The example will say 1235. Click Apply.
Comments
Add a Comment
Please sign in to leave a comment.
Tags:- csv
-
- answerbot_article_public
-
- separate
-