Contact Us

Importing Products

If you've read our help article about Creating New Products, you know that you can add new products to your Farmbrite Market through the Products Homepage.  However, we know that you if sell a lot of products, it might be time consuming to enter them individually. That's why we provide you with the ability to import your product information from a spreadsheet. This might also come in handy if you are migrating your store from a different system, or already have your products tracked in a spreadsheet. 

To get started, navigate to Market from the left menu and then select Products. From there, click the Import button

A new window will open that presents step-by-step guidelines for importing your products. 

Step 1 is to download the CSV template. Click that link, and you'll see the spreadsheet template downloaded to your computer. Our example screenshot below shows you where the file will likely be shown, but depending on your browser and device, you may need to find it on your computer- check your desktop, downloads folder, etc. 

Open the file with your spreadsheet program (probably Excel, or maybe Google Sheets, or OpenOffice), and you'll see column headers for different information about this product. Each row in your spreadsheet is used for a different product. Complete the spreadsheet with any information you'd like to add - you must at least supply a title (name) for your product. 

The following fields are available for you to  associate with this product via import. The italicized text indicates the accepted values that can be imported into that field. 

Type- What type of product are you uploading - Product, Membership, Custom, Other

Title - The name of your product. 

Available_Online - Should this item be available in your Online Store? Yes, No

Category - What category should this product be associated with? Baked Goods, Beverages, Beef Products, CBD Products, CSA, Custom, Dairy and Egg Products, Fish and Shellfish, Fiber and Wool, Flowers (Cut or Dried), Fruits and Fruit Juices, Hemp Products, Honey, Jams and Jellies, 'Lamb, Veal, and Game Products', Legumes and Beans, Nuts and Seeds, Memberships, Pork Products, Poultry, Salves and Balms, Sauces, Spices and Herbs, Soaps and Toiletries, Sweets, Vegetables and Vegetable Products, Other. 

Delivery_Options - How can this product be received by your customer? Delivery, Pick up, Shipped

Min_Order - What is the minimum quantity of this product that can be sold in an order?

Pinned - Should this item be shown at the top of it's category in your online store? Yes, No

Price - What is the retail price of this product? 

QTY_Remaining - How many of this item do you currently have for sale in your inventory? 

SKU - An internal ID or barcode string. 

Status - What is the current status of this product - Available, Back Ordered, Draft, Hidden, Sold Out

Unit_Label - In what measurement unit is this product sold? Quantity, Bales, Barrels, Bunches, Bushels, Dozen, Gallons, Grams, Kilograms, Liters, Ounces, Pints, Pounds, Quarts, Tonne, Tons

Wholesale_Only - Is this product only sold in wholesale quantities outside of your online shop? Yes, No.

Wholesale_Price- What is the wholesale price for this product when purchased in bulk by a reseller? 

You'll end up with something that looks like this:

Note that not every field needs to be filled out; supply what makes sense for your products. Be sure you've saved your spreadsheet as a .CSV file after you're done adding your products. 

Return to Farmbrite, and upload the spreadsheet by clicking the Choose File Button on the Import Records Window.  A file selection window will open; find your completed product import .csv file on your computer, and select it. 

 

Farmbrite will analyze the file, and bring you to Step 2 - mapping your fields. Essentially, this step has you connect the fields from your spreadsheet in the left column with standard Farmbrite fields shown on the right. You are basically telling the system that "the data in this column should be added to this specific field". In the example below, the column "title" from the spreadsheet is mapped to the field "title" in Farmbrite. If you used the Farmbrite import sheet, you won't  have any work to do here, as the fields will automatically match. You might just verify the mapping, and then click Import Records in the bottom right. 

The file will be imported, and you'll be presented with a Results page. You'll be alerted to successfully imported records, and any errors that may have occurred. 

If you do encounter any errors, we would first suggest that you check the data you provided in the fields to make sure it matches with the accepted values ( in italics above, in the field definition section of this article). If you think you have everything correct but are still receiving an error, reach out to us and we'll be glad to help!