This guide shows you how to use the price import fitted for the GS1 Products structure.
This guide is only of relevance if you have a GS1 product integration with effectmanager.
Importing your products to effectmanager with GS1 you can also import prices and chains that are fitted to the GS1 product structure.
In this article we will go through:
- How to set up a GS1 Products Price Integration
- How to set the correct file format for GS1 Products Price integration
- Conditions for the GS1 Products Price import
Set up GS1 Products Price integration
For you to set up a GS1 Price integration with effectmanager, you must contact support@effectmanager.com
Criteria for the GS1 price integration:
- Must be able to export the file to ftp provided by effectmanager
- Must be able to export in the file format provided below
- Must be able to export on either Wholesaler specific or Chain specific prices
File format for GS1 Products Price integration
For you to import prices fitted to the GS1 product structure, the file must fit the criteria below.
Further criteria and mapping rules, can be sent to you by email if you contact our Customer Success Manager or the support at support@effectmanager.com
- File format: .csv
- Filename: GS1Price_[Plan id]_[YYYYMMDDTTMMSS]
NB! Plan id is provided to you by effectmanager - Column Seperator: , (Comma) as column separator
- Text Separator: " (inverted commas) as text separator
- Date formats: dd-MM-yyyy, yyyy-MM-dd, dd/MM/yyyy.
- Price formats: 00,00 or 00.00
You can read more about prices in effectmanager at this link.
Conditions for the GS1 Products Price Import
To import your GS1 Price file there are some conditions that must be met, for the file import to be successful.
Wholesalers and Chains
Prices are matched to the chains created under the wholesaler unless there is a chain-specific price in the file. Then that/these chains will have the price specified in the file.
Condition: The wholesaler must be created in effectmanager with a Wholesaler Internal number and chains must be created in effectmanager under the wholesaler. The Retail Chain with specified prices must have a matching Retail Chain Internal Number.
👍Pro-tip: We can create Retail Chains in effectmanager from the Price file if the file meets the conditions set in the business rules for the import.
If you want to know more about Validation and Business rules, please contact support@effectmanager.com
Product Master Data
Prices are matched on OrdreEAN or Product internal number.
Condition: Products created in effectmanager must have an OrdreEAN or Product Internal Number to be matched to a Retail Chain price.
