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"}] |