Overview
To improve the quality of services and uninterrupted data provision, tgndata has created a process so you can automatically choose which products to monitor daily.
Advantages
• Daily valid information.
• Quick updates of your data.
• Quick solutions to provide competition data.
• Possibility of daily changes for the products you want to monitor.
• There is no impact on your servers.
• Minimization of human or systemic errors.
Prepare Auto Sync
Ways to send/receive the data
• URL: Upload your file to your server, and provide us with the link to download it (e.g., https://www.to-eshop-sas.com/tgn-sync.csv)
• FTP/SFTP Download: Upload your file to your server and provide us with FTP/SFTP credentials to download it.
• FTP/SFTP Upload: Send your file to our Servers using the FTP/SFTP credentials we will provide you with for this use.
Supported file types
• JSON File (.json): This is quite modern, requires no instructions, and is highly recommended because it cannot cause any problems to your data caused by strange/special characters.
• XML File (.xml): Quite modern, no instructions required, and just as secure as JSON.
• CSV File (.csv): Use the separator «;». Ideally, it would be good to include prices in double quotes «”» as well as to have the escape character «\\» where necessary.
File encoding
The file we receive from you should be strictly in UTF-8 encoding (without BOM).
The columns of the file
• SKU: The product identification code used in your online store or internally in your systems.
• Product Name: The title of your product as you recognize it.
• Brand: The manufacturer/brand of your product.
• Top Category: The original parent category that your product belongs to.
• Mid Category: The middle parent category that your product belongs to.
• Bot Category: The final/last category in which your product belongs.
• EAN (European Article Number): The unique number each product has or just the 13-digit barcode (EAN or GTIN13) bearing on its label.
• URL: The URL where your product can be found in your online store. It is required to monitor your prices and have valid results to compare. If any of the products you want to monitor are not visible in your online store, then you leave the column blank and consider it an “Offline product.”
• My Price: The price of your product when you create the file. If the product is “Offline,” we need that to compare it with your competition. For online products, it helps for faster updates and will also be updated by our systems during the day.
• Description: It is the column that emphasizes a feature of the product, such as color, or size (e.g., BLUE).
• MPN (Manufacturer Product Number): This is the unique manufacturer code for your product.
Notes
• SKU / Product Name / Brand / My Price are mandatory.
• The URL column should be completed if your product is active and online in
your store.
• If you have only 1 Category level, fill in the first column, "Top Category." If you fill in only this category, the rest of the categories will also have this name in our systems (Eg, 1 / Computers -> 2 / Computers -> 3 / Computers).
• If you have two Category Levels, fill in the first column and the middle “Top Category / Mid Category.» The Bot Category will automatically be identified the same as the Mid Category (e.g., 1 / Computers -> 2 / Laptop -> 3 / Laptop).
• If you have 3 Category Levels, fill in all three columns.
• In case you have four or more Category Levels, then the "Top Category" will be your parent category, the column "Bot Category" will include your last category, and the "Mid Category" will be the intermediate category that serves you best.
• The remaining columns are optional but should be in the file even if not completed.
• The order of the columns should be as mentioned above.
• The number of columns should be the same and irrevocable. If you need to modify the number or order of the columns, you should first inform us. Otherwise, a failure to update your account or loss of data is compromised.
• The synchronization is performed between 04:00 a.m. and 04:45 a.m., EET. That means your file should be uploaded (on the agreed location) before 4:00 a.m., EET. Otherwise, your account will not be updated with the data you want.
• The price should be separated by a "." dot for its decimals.
• Finally, the file’s name should be sync.csv (or sync.json, sync.xml)