Avoid multiple SKUs for the same product | How To

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 the uploading products.

How to: Format cells in Google Sheets

  1. Open file in Google Sheets
  2. Highlight the desired Column (SKU)
    highlight_sku_columns_google_sheets.PNG
  3. Select Format in the top menu
    format_google_sheets.PNG
  4. Mouse over Number- then in the side menu, select More Formats- Then select Custom number format
    number_format_google_sheets.png
  5. Select the number format with no decimals or additional characters. The example will say 1235. Click Apply.
    custom_number_formats_google.PNG

Everything will be populated as desired.

How to: Format cells in Excel

  1. Open file in Excel
  2. Highlight the desired Column (SKU)
  3. Right click and select Format Cells from the dropdown:
    format_cell_menu_excel.png
  4. Under the 'Number" tab, select the "Number" category and set decimal spaces to 0.
    format_cells_numbers_excel.png
    Then click OK.

That's it!

 

Comments

Add a Comment

Please sign in to leave a comment.

    Tags:
  • csv
  • separate
  • answerbot_article_public