CSV Product Uploads - Required Fields | Overview
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:
| ShippingEasy Column | Column Definition |
|---|---|
| *SKU | Unique identifier for the product, for example, 49381 |
| Alias SKUs |
A SKU that maps to another product. Learn more. 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. |
| 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. Learn more. |
| 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.) | Measure of the longest side of the product. Units in inches. |
| Width (in.) | Measure of the shorted side of the product. Units in inches. |
| Height (in.) | 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 product image. Must be JPG or PNG. Ex: http://mysite.com/products/49381.png 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 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: |
| 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. Learn more. 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. |
| Suppliers |
Assign a supplier to a product SKU. Suppliers must be saved to ShippingEasy before they can be mapped to Products. Learn more. When there is not a value to specify for the Supplier SKU or Unit Cost, omit that value, but do not omit any colons (:). When specifying multiple suppliers, use the following format: 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. Learn more. NOTE: only available to Inventory Management subscribers. |
| Max Available Quantity |
The stock level you want sent to your stores regardless of how much Available stock you actually have on hand. Learn more. 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. Learn more. NOTE: only available to Inventory Management subscribers. |
| 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. Learn more. |
Comments
please add "Is Active" to the list of downloaded/uploaded fields
Hi DJ - good news! You can now update the active/inactive status of your product SKUs via CSV file. Designate a column to this field, then fill the field with "active" if you would like ShippingEasy to reference that product's data. Likewise, fill the field with "inactive" if you wish for ShippingEasy to ignore that product's data.
Add a Comment
Please sign in to leave a comment.