CSV Product Uploads

Important

In order to use specific CSV fields, you must have the Inventory add-on. Existing Inventory Management subscribers will still have the ability to use the features specific to Inventory Management, however, we are no longer supporting new subscribers.

ShippingEasy supports updating your Products catalog via CSV file. This guide outlines which fields can be updated with a CSV file upload. For more help getting started:

Required Fields

Fields marked with * are required.

ShippingEasy Column

Column Definition

*SKU

Unique identifier for the product, for example, 49381

Alias SKUs

A SKU that maps to another product. Learn how to [set up SKU Aliases]. When specifying multiple Alias SKUs, use the following format:

  • SKU | SKU

  • Ex: SE123 | SE345

We can replace, not remove an Alias SKU. If you upload another alias for the same product, we will update it. If the field is blank, we take no action on that item.

IMPORTANT: include all Alias SKUs listed for your products as these values are set per upload.

Bundled SKUs

A group of product SKUs sold together. SKUs must be saved to ShippingEasy before they can be mapped to bundles. [Learn how to set up bundled products.]

For bundles with a single SKU, use the following format:

  • SKU: Qty

  • Ex: SE123: 3

When specifying a bundle with multiple SKUs, use this format:

  • SKU: Qty | SKU: Qty

  • Ex: SE123: 1 | SE345: 1

IMPORTANT: include all Bundled SKUs listed for your products as these values are set per upload.

Name

The name or description of the product. Ex: Tote bag

UPC

The Universal Product Code (UPC) of the product.

ASIN

The Amazon Standard Identification Number (ASIN) of the product.

ISBN

The International Standard Book Number (ISBN) of the product.

Weight (oz.)

Unit weight in ounces.

Ensure your file has all weights as ounces.

Length (in.)

The measure of the longest side of the product. Units in inches.

Width (in.)

The measure of the shorted side of the product. Units in inches.

Height (in.)

The measure of the height of the product. Units in inches.

Declared value

Value to declare on international shipment customs forms.

Units in US dollars.

Wholesale Price

The cost of the product to the manufacturer. Units in US dollars.

Image URL

URL of the product image. Must be JPG or PNG.

Ex: http://mysite.com/products/49381.png

The maximum file size is 1 MB.

Country of Manufacture

Country where the product was manufactured; used for international shipment customs forms.

Warehouse Bin

Current location of the product in your warehouse.

Harmonized code

Standard WCO tariff code for international shipments.

Category

Used to organize products. Each product can belong to only on Product Category. Product Categories must be saved to ShippingEasy before they can be mapped to Products. Learn about Product Categories.

Stock

Total quantity on hand. Override current levels in ShippingEasy.

NOTE: Only available to Inventory Management subscribers.

Adjust Stock

Add or subtract from the total amount of stock in ShippingEasy. To subtract, enter a negative value.

NOTE: Only available to Inventory Management subscribers.

Low Stock Threshold

The minimum value of the stock you want to have on hand and the threshold at which you would like ShippingEasy to alert you to order more stock.

NOTE: Only available to Inventory Management subscribers.

Tags

Used to assign attributes to products. [Learn more about Product Tags.]

When specifying multiple tags, use the following format:

  • Tag Name | Tag Name

  • Ex: Fragile | Perishable

Active

Used to indicate whether your products are Active or Inactive. Specify a value of Active or Inactive. [Learn more about inactive products.]

Send Inventory Updates to Store

Used to indicated whether stock levels should be updated within your store. Specify a value of On, Off, or blank. Blank will default to current settings. 

NOTE: Only available to Inventory Management subscribers.

Safety Stock

The amount of stock you always want to have on hand. Once set, the safety stock amount will be subtracted from the available stock when we send updates to your store.

NOTE: Only available to Inventory Management subscribers.

Suppliers

Assign a supplier to a product SKU. Suppliers must be saved to ShippingEasy before they can be mapped to Products. 

For a single supplier, use this format:

  • Supplier Name: Supplier SKU: Unit Cost

  • Ex: ACME: A123: 9.99

NOTE: Unit Cost is the per-unit cost of a product for a specified supplier. This may be referenced from Product and Supplier details.

When there is not a value to specify for the Supplier SKU or Unit Cost, omit that value, but do not omit any colons (:).

  • Ex: ACME: : 9.99

When specifying multiple suppliers, use the following format:

  • Supplier Name: Supplier SKU: Unit Cost | Supplier Name: Supplier SKU: Unit Cost

  • Ex: ACME: A123: 9.99 | Spacely: S345: 1.99

IMPORTANT: include all Suppliers listed for your products as these values are set per upload.

NOTE: Only available to Inventory Management subscribers.

Handling Time

The number of business days between receiving an order for a product and shipping the product. Specify the number of days. 

NOTE: Only available to Inventory Management subscribers.

Max Available Quantity

The stock level you want to be sent to your stores regardless of how much Available stock you actually have on hand. 

NOTE: Only available to Inventory Management subscribers.

Lead Time

The number of days between when your supplier receives your purchase order and the inventory is delivered to you. 

Override Store Name

Option to [override product name from your store.] This will override what comes through in the order details. It will instead display names from the product catalog. 

Video: Uploading Products (SKUs) via CSV file

ShippingEasy's Product Catalog provides a centralized hub to store all your product information. This information is then used to update your orders automatically, matching the product SKU to override data synced from your store.

Products in New Orders

If your store platforms include Amazon, Bigcommerce, eBay, Magento, Volusion, or Shopify, product catalog entries are automatically created for items included in new orders. However, there may be advantages to uploading your entire catalog proactively.

Product listings can be added one by one or all at once via CSV file (in bulk). The video below will show you exactly how to upload products via CSV file.

Comments

Add a Comment

Please sign in to leave a comment.

    Tags:
  • #pendo
  • inventory products
  • csv
  • answerbot_article_public
  • products uploads
  • products uploads mapping
  • products uploads rows
  • csv_import
  • import_data
  • product data
  • product information
  • add product