Follow

How to: Avoid multiple SKUs for the same product

Created:   |   Updated:

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!

 


Related articles:

How to: Create a CSV file
CSV Order Uploads: Sample CSV file
CSV Order Uploads: Column mapping - required fields & explanations
How to: Merge multiple columns of data in Excel without losing any data
How to: Check CSV uploads for duplicates and delete them


Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing