Importing Price-books from CSV

Importing Price-books from CSV

You can easily import your price-books from other Point-of-Sale systems by using our Pricebook-import tool available at any-time within Petro Outlet.

Preparing the File

First, the file samples:

For best results, please do not change the headers from the sample file.

Some notes on the file spec, the files have the following headers with the following restrictions/notes:

Column Name

What it is

Example & Is Required

UPC/PLU

The UPC for the product. Preferably:

  • Expanded/Padded to 14-digits (GTIN-14)

  • Includes check-digit

  • UPC-E converted to UPC-A

While these are ideals and will improve the results of the import. Petro Outlet will try to clean up the barcodes and convert/adjust automagically on the upload. Results will degrade from conversion.

07190000000001

Required: Yes

Modifier

This is part of the unique key that makes a "SKU" in our system. Typically this is 0, which represents the base-item. However, if you have 2 versions/variants of products that you wish to show at check-out you can increase this number incrementally to add more variants

Typically 0

However:

Very Commonly, 0 for Single Can, 1 for 6-Packs, 2 for 12-Packs, 3 for 18-packs ONLY when all share the same barcode.

Required: Yes

Name

The Name of a product in your pricebook. Capped at 40 characters, if you go over the system will ignore the rest of the name.

1-2-3 Vegetable Oil 12.4Oz

Required: Yes

Department

The Department of a product in your pricebook. Capped at 30 characters. If the department doesn't exist and the "Create Departments" flag is set at import, the department will be created.

Food

Required: Yes

Retail Price

The price of a product in your pricebook. This is ideally in $'s without the dollar symbol, number only.


If the pricebook is in cents, you can have the importer auto-convert with the "Convert Cents to Dollars" flag.

1.99

Required: Yes

Taxable Override

Can be any of the below, case-insensitive:

  • y

  • n

  • true

  • false

  • Blank

If blank, the product will rely solely on the settings of the department.

The columns must still be in the CSV file header.

y

Required: No

Foodstampable Override

Same as Taxable Override

Required: No

Fractional Override

Same as Taxable Override

Required: No

Tags

Not case sensitive. separate multiple tags for products with ","

Required: No

Linked SKU

For CRV etc..

Required: No

Importing the File:

1. Visit the Pricebook Importer in Store Management > Products > The Gear Icon in the Top-Right > Import from CSV:

2. Configure the processing options. accordingly, for the file you are importing, the processing options MUST be set prior to opening the file. The Import options are good to set ahead of time as well but can be delayed.

3. You will then get some statistics on the file, as well as the first 10 products previewed from the file to see if these processing options give you a good import result. If you like the result go ahead and press import, if not adjust the settings re-import using the file-picker, and try again. Please note we will ignore duplicate products (defined as a product with the same UPC & Modifier combination aka SKU).

4. Press "Import to Pricebook" and wait a moment, this can take a couple of minutes for very large price-books at peak load. Do not navigate away during import. The page should reload upon completion and you should see the pricebook.

That's it!

    • Related Articles

    • How to Add a Price Per Pound Product

      Store Management Click on Store Management (This is the 3rd item on the left-hand side menu) Click on Products This is the 4th item on the left-hand side menu Click on "+ New Product" Click on “+ New Product” (Top, Right-hand side) A menu will pop up ...
    • How to Update the Price of a Product

      Click on Store Management Click on Products Click on Products (4th item on the left-hand side menu) Search for Product You can search for a product by name or sku Click on the Product’s Name to Edit Click on the name of the product. A menu will pop ...
    • How to Manage Lottery Inventory

      Inventory & Financials From your dashboard, click on Inventory & Financials Received Books There are three tabs in this section The first tab (Received Books) is the introductory stage. This is where you will scan all new books into the system. ...
    • How to Change Prices on SuperSonic

      When looking at your screen of the POS (see below), scan the product. Press on the product so that a option screen appears. Next select Price Override and put the new price. After you put the price press Override Price. It will ask you Change Product ...
    • Bulk Product Editor

      Store Management Click on Store Management (This is 4th item on the left-hand side menu) Then click on Products to bring up the products of your store. Next press the Bulk Edit Pricebook button. This will open the Bulk Product Editor. Under "Select ...