Discover how to prepare your data spreadsheet for catalog automation or for product tag automation
Table of contents:
If you have decided to use our automation tool for automating your catalog production or for product tags, you'll want to know how to prepare your files.
Our automation tool supports multiple types of files: CSV, and XLSX, and it's also compatible with Google Spreadsheets.
Important: Automation is available with the Enterprise plan at request.
CSV is a commonly used file format that contains numbers and texts in a spreadsheet format. It's generally used for data transfer between various programs or apps. CSV files can be created, edited, and opened with Google Spreadsheets, Microsoft Excel, Numbers, or other similar programs.
If you plan on updating your data in your catalog multiple times, Google Spreadsheet might be the best option, because you can update your data on Flipsnack with a simple click on "Sync", instead of re-uploading a file.
Creating the data sheet
You could download our CSV sample from the Automation tab, to use as a starting point, or you can use a blank spreadsheet.
If your datasheet contains products, each product should be listed on a separate row, and each column should contain a specific type of information. Some examples of column headers could be SKU number, Size, Color, Fabric, Price, etc.
You can add as many columns as you wish, and name them however you want.
It's important to know that the information will appear in your flipbook exactly as it was entered in your spreadsheet, so pay attention to capitalization.
If you want to use images in your catalog, you need to add them as image links in your file.
If you plan on adding links in your automated catalog, add a column for product links and insert the links that will take the customer to your eCommerce website.
Important: If you need to update a spreadsheet that is connected to a flipbook, please remember not to modify the first row and the column that includes SKUs/ID numbers for the products. These elements have already been mapped and modifying them will impact the mapping and design of the catalog.
Working with multiple data sheets
On Flipsnack you can add multiple data files.
Let's say you already have a template ready to be populated with your products that is connected to your data source. Now you plan to reuse this ready-made, smart template with a different data sheet. Will it work?
Yes, it will, but only if you keep the same column headers for your new data file. If the same type of information is listed in your file under a different name, it will not work. For example, if a text box is set to display the information in the column "Price" and the new data file lists prices as "US Price" the system will not be able to match the information.
Preparing your file for Product tag automation
You could use the following column headers in your file: Product title, SKU, Description, Price, Discount price, Product URL, Button label, Image 1, Image 2, and Image 3.
You don't have to use the exact same names but go with something similar that will help you match the information from your file with the product tag fields.
It's not necessary to add all of these columns if you don't want some type of information to appear in your product tag. For example. you can simply skip the button label and product URL if you don't want to link to an external webpage. The same goes for images, prices, or discounted prices. It's up to you what to include as product tag automations are ideal to host details about your products.
If you have any more questions about preparing a spreadsheet for Flipsnack automation, don’t hesitate to contact us via live chat.