UPC

Accepted values: (number), up to 13 digits

SKU Number

Accepted values: (numbers and letters)
Notes: Can be used in lieu of Style ID, Option Code, and Size when updating inventory

Style ID

Accepted values: (numbers, letters, standard characters)

Name 

Accepted values: (numbers, letters, standard characters)

Option Code

Accepted values: (numbers, letters, standard characters)

Option Name

Accepted values: (numbers, letters, standard characters)

Size

Accepted values: (numbers, letters, standard characters)
Notes: Can be omitted if updating other attributes uniformly

Description

Accepted values: (numbers, letters, standard characters)

Wholesale (***)

Header Notes: 

  • ***  = Currency abbreviation, e.g. "Wholesale (USD)"
  • If Optional ID Code is used, add a space and the characters after, e.g. "Wholesale (USD DIS)"

Function: Set Wholesale Price value for specified Price List
Accepted values: (Price), do not include currency in value

Retail (***)

Header Notes:

  • ***  = Currency abbreviation, e.g. "Retail (USD)"
  • If Optional ID Code is used, add a space and the characters after, e.g. "Retail (USD DIS)"

Function: Set Retail Price value for specified Price List
Accepted values: (Price), do not include currency in value

Type

Accepted values: (numbers, letters, standard characters)

Category

Accepted values: (numbers, letters, standard characters)

Season

Accepted values: (numbers, letters, standard characters)

Ship Date

Accepted values: (date), format as MM/DD/YY

Minimum Quantity

Accepted values: (number)

At-Once Inventory

Header: Inventory Count
Accepted values: 

  • (number) = overwrites existing value if different, skips if same
  • (number)! = same as standard update but forces overwrite of existing value when same, forces inventory table update
  • (empty) = ignored by import, SKU maintains existing count
  • "INF" = resets the the inventory back to blank or infinite

Future Inventory Count (add-on)

Accepted values: 

  • (number) = overwrites existing value if different, skips if same
  • (number)! = same as standard update but forces overwrite of existing value when same, forces inventory table update
  • (empty) = ignored by import, SKU maintains existing count
  • "INF" = resets the the inventory back to blank or infinite

Inactive (add-on) 

Function: Set SKU to Active/Inactive
Accepted values: 

  • true, T, Yes, or y
  • false, F, No, or n

Sellable (add-on)

Function: Set SKU to Enable/Disable Selling
Accepted values:

  • true, T, Yes, or y
  • false, F, No, or n

Image URL (add-on)

Did this answer your question?