Studio Excel file
The sheets and columns of the Excel file that holds a Studio project, for reading it, editing it in Excel and uploading it again.
A Studio project is one Excel file. Studio reads it when you upload it, and writes it when you choose Download under Project actions.
Most changes are easier in Studio itself. If you do edit the file, keep a copy first: undo cannot go back past an upload.
Sheets
| Sheet | Holds |
|---|---|
Configuration |
The project’s settings. Change them in Studio |
products |
One row for each product in the project |
scenario … |
One sheet for each fixture: where every product sits |
Leave any other sheet as it is.
The products sheet
| Column | Holds |
|---|---|
id |
The product’s ID. No two products can share one |
name |
The product’s name |
price |
The price in pence or cents: 250 for 2.50 |
width, height |
The product’s size, in millimetres |
gtin |
The product’s barcode number |
image_url |
The web address of the product’s image |
tags.… |
A tag, such as tags.brand |
A fixture’s sheet
Each row is one product’s place on the fixture.
| Column | Holds |
|---|---|
product_id |
The product, by its id in the products sheet |
bay, shelf |
The numbers of its bay and its shelf |
position |
Its order along the shelf |
facings_wide, facings_high |
How many facings sit side by side, and stacked |
The numbers set an order, and can start at 0 or 1. Keep bay numbers to 50 or less, and shelf numbers to 20 or less. Bay Order and Shelf Order, in Settings, decide which way they run.