Products

Files

File Type Description
products/product.csv main The products to import.

Fields

products/product.csv

Field Required Type Description
id required string The id of the product.
code required string The code (short name) of the product.
name required string The name (full name) of the product.
price required money The default price of the product.
stock required integer Should be -1 for unlimited stock, -2 for calculated stock (for packages), or a positive integer representing the current inventory total of the product.
is_taxable required boolean Wether or not this product should be subject to order taxes.
expiration required integer The expiration in days that a contract for this product should expire.
packaged_products[].product.id required relation:"products.id" For packages, indicate the ID of the bundled product.
packaged_products[].quantity required integer For packages, indicate the quantity of the bundled product.
packaged_products[].unit_price required money For packages, indicate the unit price of the bundled product.
product_status required product-status Indication if the product is active or archived.
categories[].id required relation:"categories.id" The ID of the category this product should be linked to.
product_type required product-type Indicates wether this product is a product, service , or a package.

Required Rows

code name product_status product_type categories
ADJ Adjustments active product [{"id":"id-for-MISC"}]
OPEN Opening Record active package [{"id":"id-for-MISC"}]
PRI1 Private Lesson active service [{"id":"id-for-PRIVATE"}]
PRI2 Routine Lesson active service [{"id":"id-for-PRIVATE"}]
PRI3 Private Three active service [{"id":"id-for-PRIVATE"}]
PRI4 Private Four active service [{"id":"id-for-PRIVATE"}]
CMP Complimentary active service [{"id":"id-for-PORI"}]
GRP1 Group active service [{"id":"id-for-CLASS"}]
GRP2 Group Two active service [{"id":"id-for-CLASS"}]
GRP3 Core Rhythm active service [{"id":"id-for-CORE"}]
PRT Party active service [{"id":"id-for-PARTYTIME"}]
NPRI Coaching Private active service [{"id":"id-for-NUNIT"}]
NCLASS Seminar active service [{"id":"id-for-CLASS"}]
PCMP Paid Complimentary active service [{"id":"id-for-PORI"}]
NCMP Non-Paid Complimentary active service [{"id":"id-for-PORI"}]
NONE Miscellaneous Service active service [{"id":"id-for-MISC"}]