To export the items retails to PIM from a file, fill this file with the items retails data based on the rules below.
Items that don't meet these conditions will not be exported.
- SKU: Item barcode.
- SKU Type: Item barcode type. Following are the values used for the supported code types:
- 0: Used for the UPC-A code.
- 1: Used for the UPC-E code.
- 2: Used for the EAN-8 code.
- 3: Used for the EAN-13 code.
- 4: Used for the PLU code.
- 5: Used for the GTIN code.
- 6: Used when no other code is specified for the item.
- Name: Item name. This field is used for information purposes only, its value will be displayed but will not be imported or processed.
The SKU, SKU Type, and Name values of each item in the file must match exactly the item SKU, SKU type and name in CStoreOffice®. - Recommended Retail: Item recommended retail value.
- Recommended Retail Start Date: A date from which the new Recommended Retail value must be applied. If this field is not empty, this means that the Recommended Retail is an upcoming value.
- Min/Max Recommended Retail: Item Min/Max retail value. During data loading, the system validates loaded information using the following rules:
- Min Retail <= Current Retail, Recommended Retail
- Max Retail >= Current Retail, Recommended Retail
- Min-Max Recommended Retail Start Date: A date from which the new Min Retail/Max Retail values must be applied. If the field is not empty, this means that Min Retail and Max Retail are upcoming values.
- Apply Recommended Retail: Select one of the following two options:
- 0: The recommended retail is applied for the selected stations, but not sent to the cash registers. This value is selected by default.
- 1: The recommended retail is applied for the selected stations and sent to the cash registers.
- Negotiated Cost: Item cost value.
- Negotiated Cost Start Date: Date from which the new Cost value must be applied.
- Promotion Cost: The item's promotion cost which is set up and used regardless of the item's participation in an active promotion.
- Promotion Cost Start Date: A date from which the new promotion cost value must be applied.
- Promotion Cost End Date: A date at which the new promotion cost must be ended.
- Vendor ID: Vendor identifier for the provided negotiated cost value.
- Vendor: Vendor name for the provided negotiated cost value. This field is mandatory if the Negotiated Cost value is provided.
- Vendor GL#: Vendor GL account number for the provided negotiated cost value.
- Vendor Tax ID: Vendor Tax ID for the provided negotiated cost value.
- VIN: Vendor identification number for the item.
- Units in Case: The number of items in a package or set from the vendor.
- Status: Item status. Possible values:
- 0: Item will be active for sale.
- 1: Item will be inactive for sale.
- Immediately, if the Status Start Date field is empty
- From the Status Start Date, if that field is not empty.
- Status Start Date: Date from which the new Status value must be applied.
If these conditions are not met, the corresponding record will be marked red and shown at the top. Users can correct the data to be sent to PIM. After correcting the data in the fields and saving it, the data is re-validated.
The item's barcode or code, in case of error, cannot be updated manually. To upload these items to PIM, you need to correct the code value in the file and upload it again.
The status will be applied:
For date fields, you can use date formats with any separators.
