Skip to main content

Importing & Exporting Products

You can bulk import products to create and update your products with a CSV file. It works best when you start from an Endless product export, make your changes, and import the updated file back into Endless.

How It Works​

Product import is an upsert workflow. If a row's SKU matches an existing product in the selected brand, that product is updated. If the SKU does not match, a new product is created.

When a row updates an existing product, blank values are treated as no change and will not replace existing values.

Before You Begin​

Use SKU values consistently, decide whether each row is meant to create or update a product, and start from an Endless export whenever possible. Header names are flexible about capitalization and spacing, but using the exported names is the safest option.

Columns​

Required Columns​

  • Name - Product name.
  • SKU - Main identifier used to match an existing product for updates.

Core Product Fields (Optional)​

  • UPC - Product UPC code.
  • Part Number - Internal or manufacturer part number.
  • Description - Product description text.
  • Product Type - Options are part, base_item, bundle and non_inventory. When creating a new product, this will default to base_item if this column is omitted. base_item is often referred to as Finished Good in the app.
  • Archived - Controls status. Yes marks the product archived; other values are treated as active.
  • UOM - Unit of measure.
  • Image - One or more image URLs. Multiple values can be comma-separated.
  • Tags - Product tags. Multiple values can be comma-separated.

Base Dimensions (Optional)​

  • Weight - Base product weight.
  • Length - Base product length.
  • Width - Base product width.
  • Height - Base product height.

Pricing And Inventory Settings (Optional)​

  • MSRP - MSRP price value. Do not include the currency symbol.
  • MAP - MAP price value. Do not include the currency symbol.
  • Restock Threshold - Quantity threshold used for restocking logic.
  • Shippable - Options are Yes, No. Defines whether the product can be added to orders and fulfilled. Yes becomes true.

Product Documentation (Optional)​

  • Packaging URL - Link to packaging documentation.
  • Specs URL - Link to specs documentation.

Purchasing (Optional)​

  • HTS Code - Customs HTS code.
  • HTS Name - Customs HTS description or name.
  • Country Of Origin - Country of origin for customs data.
  • Duty Rate - Base customs duty rate.
  • Sourcing Method - How the product is sourced.

Shipping Package Fields (Optional)​

  • Shipping Weight - Shipping package weight.
  • Shipping Length - Shipping package length.
  • Shipping Width - Shipping package width.
  • Shipping Height - Shipping package height.
  • Package Type - Shipping package type.
  • Ship Ready Packaging - Whether the item uses ship-ready packaging. Yes becomes true.
  • Shipping Package - Shipping package label or type text.
  • Weight Factor - Shipping weight factor value.

Inner Pack Fields (Optional)​

  • Inner Pack GTIN - Inner pack GTIN.
  • Inner Pack Quantity - Inner pack quantity.
  • Inner Pack Weight - Inner pack weight.
  • Inner Pack Length - Inner pack length.
  • Inner Pack Width - Inner pack width.
  • Inner Pack Height - Inner pack height.

Master Carton Fields (Optional)​

  • Master Carton GTIN - Master carton GTIN.
  • Master Carton Quantity - Master carton quantity.
  • Master Carton Weight - Master carton weight.
  • Master Carton Length - Master carton length.
  • Master Carton Width - Master carton width.
  • Master Carton Height - Master carton height.

Pallet Fields (Optional)​

  • Pallet GTIN - Pallet GTIN.
  • Pallet Quantity - Pallet quantity.
  • Pallet Weight - Pallet weight.
  • Pallet Length - Pallet length.
  • Pallet Width - Pallet width.
  • Pallet Height - Pallet height.

Cost Fields (Optional)​

  • Landed Cost - Product economics landed cost. Do not include the currency symbol.
  • BOM Cost - Product economics BOM cost. Do not include the currency symbol.
  • Unit Cost - Product economics unit cost. Do not include the currency symbol.
  • Packaging Cost - Product economics packaging cost. Do not include the currency symbol.
  • Inbound Freight Cost - Product economics inbound freight cost. Do not include the currency symbol.
  • Duties Cost - Product economics duties cost. Do not include the currency symbol.

Custom Attributes​

  • custom.<handle> - Custom product attribute column. <handle> must match an existing product attribute definition handle, such as custom.color. You should set these up in Endless before importing.

CSV Examples​

This is the smallest recommended file:

Name,SKU
Classic Tee,TEE-001
Logo Hat,HAT-001

This example updates existing products by SKU:

Name,SKU,Description,MSRP,Archived
Classic Tee,TEE-001,Updated short sleeve tee,29.99,No
Logo Hat,HAT-001,Updated embroidered cap,24.99,Yes
Name,SKU,custom.color,custom.material
Classic Tee,TEE-001,Red,Cotton

Limits And Results​

The product import tool is meant for product record data such as core fields, dimensions, pricing, tags, image URLs, customs and shipping fields, packaging fields, and custom attributes. It is not meant for inventory quantities or bundle composition management.

Extra columns are allowed, but unsupported columns are ignored. Blank rows are skipped. After import, Endless reports how many rows created new products, updated existing products, and failed. Rows are processed individually, so one bad row does not prevent other valid rows from importing.

Troubleshooting​

If a row created a new product when you expected an update, the SKU most likely did not match an existing product in the selected brand.