Import & Export

Import & Export

Product information can be imported and exported using XLSX files.

Import

  1. From your FastCommerce admin, go to Products > Import.
  2. Click Download Product Template.
  3. Prepare product data in Excel using the template and save as CSV file.
  4. Click Upload File, and select your prepared file to import.
  5. In the pop-up preview window, click Import.

Export

  1. From your FastCommerce admin, go to Products > Export.
  2. Click the radio button in front of “All products” if you want to export all products; Click the radio button in front of “Select products to export” if you want to export selected products.
  3. Click Export in the upper right corner of the page.
  4. You will receive an email with the list of exported products.

File Format

When you create a product XLSX file to import new products, the only required columns are Title and status. When you update products using a XLSX file, the only required columns are Product ID, Title and status.

COLUMN HEADING
COLUMN VALUE
Product ID
Product ID is the unique identifier of a product. The Product ID is assigned automatically when the product is created if you did not input it yourself. The Product ID is required when you update products using an XLSX file. Variants of the product have the same Product ID and Title. Product ID must be less than 100 characters.
Title
Title is the name of the product. Title is required when you create a product XLSX file to import new products. Title must be less than 100 characters. 
SKU
SKU is the product’s stock-keeping unit (SKU) number. SKU is one of the two columns that uniquely identify a product. Barcode is the other. Sku must be less than 30 characters.
Barcode
Barcodes are used to identify and track products at different stages of the supply chain, such as in fulfillment centers to track inventory, on invoices to assist in accounting, or as a part of purchase process in retail stores. Barcodes is one of the two columns that uniquely identify a product. SKU is the other. Barcode must be less than 50 characters.
Status
Status refers to the current availability of a product. It has 3 values: "Active", "Draft" and "InActive". Status is required when you create a product XLSX file to import new products.
Featured
Featured refers to whether a product is highlighted or prominently displayed on the store website. It has 2 values: "Yes" and "No".
Description
Description refers to a detailed written explanation or summary of the product. It can be written in plain text or HTML format.
Price
Price refers to the regular, standard price at which a product is sold under normal circumstances. Price must be a decimal up to 6-digit integer, 2-digit decimal. 
Sale Price
Sale price is a discounted price offered for a limited time or under specific conditions. Sale Price must be a decimal up to 6-digit integer, 2-digit decimal. 
List Price
List price, also known as the "manufacturer's suggested retail price" (MSRP) or "recommended retail price" (RRP), is the price suggested by the manufacturer or supplier as the standard price at which the product should be sold by retailers. List Price must be a decimal up to 6-digit integer, 2-digit decimal. 
Inventory
Inventory refers to the quantity of each product that is currently available for sale.
Product Type
ProductType must be "Physical" for now.
Weight
Weight refers to the physical weight of each product. Weight must be a decimal up to 4-digit integer, 2-digit decimal.
Weight Unit
Weight units must be "lb","oz","kg","g".
Page Title
Page Title refers to the title or name given to a specific page where the products are listed. Page Title must be less than 70 characters. 
Meta Description
Meta Description serves as a concise description of the page's content and is often displayed in search engine results pages (SERPs) below the page title. Meta Description must be less than 320 characters. 
Categories
Categories refer to the classification or grouping of products based on shared characteristics, features, or purposes. Category name can not include "#" and ">", and must be less than 100 characters. Categories must be spliced by categoryPaths with "#". CategoryPath must be spliced by category names with ">". Such as Electronics>Cable#Semiconductor Equipment>AMAT
Media Urls
Media Urls are the Url of the product images. Each url can not include "," and must be less than 200 characters. Media Urls must be spliced by ",". You can get the Media Urls in File Manager or you can use a web address. 
Tags
Tags refer to keywords or descriptive terms associated with each product. Each tag must be at least 3 characters. Tags must be spliced by "," and must be less than 200 characters.
Related Products Sku
Related Products Sku must be spliced by ",".
Option Name
Option Name is the attribute of a product, such as “color”, “size. Option Name must be less than 20 characters. 
Option Value
Option Value is the value of an option, such as “red”, “Large”. Option Value must be less than 20 characters. 
Variant
Variant refers to a specific combination of options that define a unique version of a product.
Variant Media Urls
Variant ImageUrls must be spliced by ",". Each imageUrl could not include "," and must be less than 200 characters.
Variant Price
Variant Price must be a decimal up to 6-digit integer, 2-digit decimal. 
Variant Inventory
  Variant Inventory must be an integer up to 8-digit.

    • Related Articles

    • Customers

      When a new customer makes a purchase from your store, their name and contact information are automatically added to your customer list. A customer profile is created when a customer interacts with your business in any of the following ways: Signing ...