Marketplaces > Marketplaces G-M > Galeries Lafayette > FAQ > Galeries Lafayette - How to Upload Sales Prices
Galeries Lafayette - How to Upload Sales Prices
ATTENTION: Keep in mind! •Prices and Sales Prices are not managed with price catalogue. •Timing details for start and end dates are not sent to the channel. |
Galeries Lafayette regularly offers discounts during limited-time sales promotions. Articles that are part of a sales promotion are advertised by the channel and receive a special ranking in the shop. This guide shows how you can participate in sales promotions.
CSV-Settings
The required data must be provided in a CSV file. This file has to match the settings for separators, text delimiters, and character set coding you have configured at "Admin > Import > Settings" in the section "CSV Import". The decimal separator has to be a period.
File Name
The file's name follows the standard rules for article import files. That means you need to use the format "ARTICLE_<timestamp>.csv".
Structure of the CSV File
How to upload sales prices to Galeries Lafayette in a CSV file
Column headers: All column headers, apart from the first one, have to contain the channel sign and the promotion's key. The channel sign indicates for which channel the promotion is valid (in this case, the sign is "[glfr]" for Galeries Lafayette). The key that identifies the promotion can be chosen freely but needs to be unique to avoid mix-ups.
Column |
Description |
|
|---|---|---|
|
a_nr or a_ean |
The article number or EAN. The headline must correspond to the column's contents. |
|
a_vk_sale[channel sign][promotion key] |
Discounted retail price (gross); use periods as decimal separators. |
|
a_sale_period_from[channel sign][promotion key] |
Discount start date. |
|
a_sale_period_to[channel sign][promotion key] |
Discount end date. |
|
a_sale_period_code[channel sign][promotion key] |
Code used to identify the promotional period. |
It is possible to transfer information for multiple promotional periods in a single file. In that case, you need to indicate the individual periods with different keys. TB.One then always exports the prices which match the current date.
Private Sales
Apart from the traditional sales promotions, Galeries Lafayette also offers so-called Private Sales. Discounts which are part of a Private Sale, are only available to customers who have a Galeries Lafayette account.
The channel decides when it is possible to offer Private Sale discounts. New Private Sales are announced by e-mail one month in advance. If you would like to discount articles for a Private Sale, you need to indicate this in the CSV file. To do so, prefix the keys in the column headers with "VP_".
How to participate in Private Sales by uploading a CSV file
ATTENTION: The channel can only display one promotional program for each article at any given time. If overlapping promotional periods are indicated in the CSV, only the promotional sale with the most recent starting date is available to customers. |
Uploading the Prices to TB.One
Upload the CSV file to the "in" directory using your account's FTP access. It will be processed during the next regular import.
Transfer of Sales Prices to the Channel
The price list has to be transferred to the channel before the promotional period starts. Make sure that TB.One can process your files on time.
It is possible to change prices during a promotion. In that case, the indicated starting date must be identical to the date on which the data are transmitted to the channel.
Downloading the Current Sales Prices
At "Channels > Galeries Lafayette > Settings", you can find the option "Download current sales prices" on the tab "Pages" in the left navigation bar. Use it to check which promotional prices are currently stored for the channel.
The prices are exported to the channel automatically, following the standard export schedule for offer updates. Until further notice, it is not possible to trigger exports manually via the link in the left sidebar. In urgent cases, contact Tradebyte Support for an immediate update.
Deleting Outdated Prices
To clean up the database and to avoid unnecessary exports to the channel, delete the price lists for past promotional periods. To do so, click on "Delete deprecated sales prices" on the tab "Pages" in the left navigation bar at "Channels > Galeries Lafayette > Settings".