Please download this file and load it with the detailed information for each of the products you want to us to upload into your WooCommerce store. Providing this data in an organized fashion facilitates a quicker more efficient load. Once you have the file loaded, please submit the form you’ll find at the bottom of this page that will provide us with the other details we’ll need to configure your online store.
Descriptions for each Column of the Woocommerce Products Spread Sheet
The *(Column XX)” numbers below represent each respective column in our ‘Woocommerce-Products.csv’ file.
Adding a Product
Before adding your first product, let’s get familiar with how product categories, tags, and attributes work.
Product Types (Column 01)
With attributes and categories set up and stock management configured, we can begin adding products. When adding a product, the first thing to decide is what type of product it is, here are the options.
- Simple – covers the vast majority of any products you may sell. Simple products are shipped and have no options. For example, a book.
- Grouped – a collection of related products that can be purchased individually and only consist of simple products. For example, a set of six drinking glasses.
- Virtual – one that doesn’t require shipping. For example, a service. Enabling this disables all shipping related fields such as shipping dimensions. A virtual product will also not trigger the shipping calculator in cart and checkout.
- Downloadable – activates additional fields where you can provide a downloadable file. After a successful purchase, customers are given a downloadable file as a link in the order notification email. This is suitable, for example, for a digital album, PDF magazine, or photo.
- External or Affiliate – one that you list and describe on your website but is sold elsewhere.
- Variable – a product with variations, each of which may have a different SKU, price, stock option, etc. For example, a t-shirt available in different colors and/or sizes.
- Other types are often added by extensions. For example, WooCommerce Subscriptions adds new product types as does WooCommerce Bookings.
SKU (Column 02)
SKU (StockKeeping Unit) is an identification, usually alphanumeric, of a particular product that allows it to be tracked for inventory purposes. Typically, SKU is associated with any purchasable item in a store or catalog. The SKU identification for a product may or may not be made visible to a customer.
Name (Column 03)
The title of the Product listing.
Is featured? (Column 04)
Whether the product is promoted in product categories, related products as a Featured Product.
Visibility in catalog (Column 05)
Whether the product will be shown in product catalog.
Short description (Column 06)
This typically appears next to product imagery on the listing page, and the long description appears in the Product Description tab.
Description (Column 07)
This consists of each and every detail of the product that you want to display on a single product page.
Stock (Column 08)
Enter the Stock Quantity, and WooCommerce auto-manages inventory and auto-updates Stock Status as Stock, Out of Stock or On Backorder.
Backorders allowed? (Column 09)
Select whether to Allow Backorders.
Weight (kg), Length (cm), Width (cm), Height (cm) : (Column 10 – Column 13)
Weight – Weight of the item.
Dimensions – Length, width and height for the item.
*These fileds are used by the shipping calculator.
Sale price & Regular price (Column 14 – Column 15)
Regular Price – Item’s normal/regular price.
Sale Price – Item’s discounted price that can then be scheduled for certain date ranges. The sale expires at 11:59pm of the specified end date.
Categories and Tags (Column 16 – Column 17)
This would help to you to categorize simillar products under the same category or tag.
External URL and Button text (Column 18 – Column 19)
Only applicable for ‘External or Affiliate’ Products.
Download 1 Name and Download 1 URL (Column 20 – Column 21)
Only applicable for ‘Downloadable’ products.
Attributes (Column 22 – Column 31)
*Only applicable for ‘Variable’ products.
Variable products are arguably the most complex of product types. They let you define variations of a single product where each variation may have a different SKU, price or stock level.
Product Images (Should attach with form below)
There should be a featured image for each simple product and then different images for each variation (optional) in the case of a variable product. Also, some additional images can be displayed in a product gallery section.