14

Importing and exporting products

A spreadsheet is the quick way to add a long list of products or to change many prices at once. This chapter covers the file Roadside writes, the file it reads back, and how an import decides what to change.

Export your products

Where to find itProducts›ProductsStore owner, Manager, Staff, Read only

Press Export CSV at the top of the Products list. Your browser downloads a file named like products-2026-10-08.csv. A CSV file is a plain spreadsheet that Excel, Google Sheets and Numbers all open. It holds every product that is not archived, A to Z. The columns are SKU, Name, Brand, Category and Size. Six Option columns follow: Option 1 name, Option 1 value, Option 2 name, Option 2 value, Option 3 name and Option 3 value. Then come Price, Cost, On hand, Reorder point, Hold back for the store, Tax class, Sell online, Status, Barcode and Description.

The file has one row for each size, or one for each combination when a product has options. A product with a 50 lb bag and a 20 lb bag has two rows, each with that size's SKU, price, cost and stock, and the product's name, brand, category and the rest repeat on both. A product with options has its choices in the six Option columns and nothing in Size. It also includes your Cost column. Everyone who can open Products can export, Staff and Read only people included, so treat the file the way you treat your price book. Importing is for the Store owner and Managers. Description in the file is the product's short summary, not the full description.

Import a spreadsheet

Where to find itProducts›Products›ImportStore owner, Manager

The easiest way to start is to export, change the file, and import it back. Roadside reads the same columns it writes. A file you export and import straight back, with the update box ticked, changes nothing.

SKUNameBrandCategorySizePriceCostOn hand
475716% Layer PelletsMid-South FeedsPoultry50 lb bag14.5010.4014
13ShowTime 27/20Mid-South FeedsDog50 lb bag38.0031.2011
3307ShowTime 27/20Mid-South FeedsDog20 lb bag17.7514.603
The Import products screen.
  1. 1Choose a CSV file, up to 2 MB.
  2. 2Or paste the rows, header row first.
  3. 3Tick it to change products you already have or add sizes to them.
  4. 4Runs the import.
  5. 5The columns Roadside reads.
  6. 6How a row finds the product and size it is for.
The Import products screen.
  1. Make the first row the column names. Each row needs a SKU or a Name, and a new product also needs a Price. The rest are optional, in any order. Columns Roadside does not know are ignored, and the result names them.
  2. Write sizes in words such as 50 lb bag. The section on sizes says how.
  3. Save the file as CSV. In Excel, choose CSV UTF-8 (Comma delimited). In Google Sheets, choose File, Download, Comma-separated values.
  4. Open Products, then Import and choose the file, or paste the rows into the box.
  5. Leave the update box unticked unless the file changes products you already have or adds sizes to them.
  6. Press Import. Read the banner at the top of the screen and the list under it.
  7. Check the new products. An import does not bring photos or a full description. Add those in the editor. New products arrive as Drafts, which stay off the website: open each one and press Put it on the website when it is ready, or give the file a Status column that says For sale.

The columns Roadside understands

Column names are not case sensitive. If your spreadsheet already has a different name for one, Roadside knows several.

ColumnAlso understood asWhat it holds
SKUItem number, Item #, Variant SKUThe size's item number. It is how an update finds the size.
NameProduct, Product name, Item, TitleThe product's name. Needed when the row has no SKU. A row that leaves it empty and repeats a Handle (as Shopify's files do) belongs to the product named on the first row with that Handle.
BrandManufacturer, Make, VendorA brand you do not have yet is created.
CategoryDepartmentA category you do not have yet is created.
SizeSize / unit, Unit, Unit label, Pack sizeSee below. Not used on a row that has option values.
Option 1 name, Option 1 value (and the same for 2 and 3)Option1 Name, Option Name 1One option of a product and the choice this row has in it, such as Waist and 34. See Products with options.
PriceRetail, Retail price, Variant PriceLike 22.50. Needed for a new product or a new size.
CostCost per itemWhat you pay.
On handStock on hand, Quantity on hand, Qty on hand, Stock, Variant Inventory QtyThe count when you exported, for reference. It only sets the opening stock of a new product or a new size.
CountCounted, Stock countWhat is on the shelf. The one column that changes stock you already have.
Reorder pointMinWhen the size shows as low.
Hold back for the storeHold back, Held back, Hold for storeHow many of the size the website treats as already sold, so they stay on the shelf for walk-in customers. A blank cell leaves it as it is.
Tax classTaxable, TaxOne of your sales tax classes by name, such as Livestock and poultry feed, or yes or no. Yes keeps a taxed class and no keeps an untaxed one. Otherwise yes means plain Taxable and no means Not taxed.
Sell onlineOnlineYes or no. No sets the product to Hidden. Yes puts a Hidden product back on the website.
StatusDraft, For sale or Discontinued. A new product is a Draft unless this says otherwise. A regulated product without its cautions cannot become For sale this way: its row is skipped and the banner says why. An import never archives a product.
BarcodeUPC, Variant BarcodeThe digits under the bars.
DescriptionThe product's short summary, not the long description.

The export puts an apostrophe in front of a cell that starts with =, +, - or @, so a spreadsheet does not read it as a formula. The import takes it off again.

How to write a size

Roadside needs the size as an amount, a unit and what it is sold as: 50 lb bag, 1 gal jug, 2.5 cu ft bag, 100 ct box, or just each. It understands the usual spellings, so lbs and pound work for lb. A size it cannot read skips the whole row, and the banner shows which row and what it saw: Size "5 pounds of grain" wasn't understood. Write it like "50 lb bag", "1 gal jug", "100 ct box", "each" or "Box of 3 × 1 g pouches". The last one is a size with pieces inside (Chapter 11, Sizes, prices and photos).

Update products and add sizes

Each row is for one size of one product, or one combination when the product has options. Roadside finds that size like this:

  • A filled-in SKU finds the size with that SKU, whichever size of the product it is.
  • Without a SKU, the row finds the product with exactly that Name (capitals and spacing aside) and, of its sizes, the one its Size cell names. Leave Size blank only when the product has one size.
  • A row that could mean more than one size is skipped, and the banner says why. Fill in the SKU.
  • A row that matches nothing adds a new product.

A new product starts as a Draft, counted, with the Count or On hand number as the opening stock. Sell online left empty means yes.

With Update products that already exist ticked, a row that finds a size changes it. This is how you change many prices at once. With the box unticked, the row is skipped and the banner says so: SKU 4757 already exists (tick "Update products that already exist" to change it). Because rows without a SKU find products by name and size, importing the same file twice does not give you every product twice.

An update changes only what a cell says. A blank cell, or a column the file does not have, leaves that detail as it is, so a file cannot empty a field. Price, Cost, Barcode, Reorder point, Hold back for the store and Count change the row's size. The other columns change the product. When two rows for the same product disagree, the first one that changes a detail keeps it, and the result says so on the later row. A row found by its SKU can rename the product. A row found by its name keeps the name. A product's status stays as it is unless the file has a Status column.

Adding a size

With the update box ticked, a row with no SKU, the name of a product you have and a Size that product does not have adds that size to the product. The row needs a Price, and the new size takes its Cost, Barcode, Reorder point and Hold back for the store. Roadside makes the SKU. The opening stock is the row's Count or On hand, and the size counts stock when the row gives one of those or the product's other sizes are counted. The product's own details are not changed by that row. With the box unticked, the row is skipped and the banner says how to add it.

Products with options

A product with options, such as jeans in Waist, Length and Color, has one row for each combination it carries. Put each option's name and the row's choice in the Option columns, and leave Size empty. Options: Waist, Length and Color, in Chapter 11 explains options and combinations. Files from Shopify and Square work as they are.

NameOption 1 nameOption 1 valueOption 2 nameOption 2 valueOption 3 nameOption 3 valuePriceCount
Original Fit JeanWaist34Length30ColorBleach32.004
Original Fit JeanWaist34Length32ColorBleach32.002
  • A row finds its combination by its SKU, or else by the product's exact name and a choice for every one of its options. Give each option once on a row. Roadside refuses a row that does not, with The row names the Waist option twice.
  • A name Roadside does not have yet adds a new product, a Draft unless its Status says otherwise. It gets every option and choice that name's rows give, in the order of the file, and its other rows add their combinations.
  • With Update products that already exist ticked, a row can also carry a combination the product does not carry yet, add a choice to an option it has, or add an option, up to three. When you add an option, the product's combinations take that option's first choice. A new combination needs a Price. Without the tick, the row is skipped and the banner says so.
  • Price, Cost, Barcode, SKU, Reorder point, Hold back for the store and Count change the row's combination, as they do a size. A combination that is not counted leaves Count alone.
  • An import never removes an option or a choice, and never stops carrying a combination.

Change stock with a Count column

The On hand column in the export is for reference. An import never applies it to a size you already have, so an old file brought back cannot set your stock back to last month's numbers. When it skips that column, the banner says Columns not used for products that already exist: On hand.

To change stock with a file, add a column named Count with what is on the shelf. When a count differs from what Roadside has, the import records a count in the size's stock history, with a note that names the import and the row. Sizes that do not track stock are left alone. For a new product or a new size, Count or On hand is the opening stock, and Count wins when the file has both. A column named Quantity is not read as stock, because it could mean anything, and the banner lists it under columns not used.

Read the result

When the import finishes, a banner at the top says how many products were added and updated, how many sizes were added, how many rows were skipped and how many matched and changed nothing. It lists the skipped rows with the reason, up to 50. Under the banner, a table lists every row that added or changed something, with the product, the size and each change as the old value and the new one. The row number is the spreadsheet's row, counting the header as row 1. Each row is saved on its own, so one bad row does not stop the others and a skipped row leaves nothing behind. Fix the skipped rows and import only those.

The result of an import that adds a product, changes a price and a count, adds a size, and has one row to fix.
  1. 1Added, updated, sizes added and skipped.
  2. 2Each skipped row, with the reason.
  3. 3Opens the Products list.
  4. 4What each row added or changed.
The result of an import that adds a product, changes a price and a count, adds a size, and has one row to fix.

A few messages stop the whole file before any row is read: Choose a CSV file or paste the rows., The file needs a header row and at least one product., The header row needs a "SKU" or a "Name" column., Import up to 5,000 products at a time. and That file is too large. The limit is 2 MB. Rows that fail show the reason after the product's name: Give the product a name., Enter a price (0 is fine for items you don't sell)., Price must be an amount like 22.50., Another product already uses the barcode and the size message above. Two more name a SKU that cannot be reused: SKU 4757 belongs to a size that was removed from "16% Layer Pellets". Add the size back on the product's page first, or give this row another SKU. and SKU 4757 belongs to "16% Layer Pellets", which is archived. Restore it first, or give this row another SKU. A Tax class that does not match skips the row: Tax class "Taxable goods" isn't one of this store's (Taxable, Not taxed). Write one of those, or yes or no. with your own classes listed.

Something here does not match your screen? Write to support@dirtroadsoftware.com with the name of the screen, what you pressed and what you expected. A picture of the screen helps.