Store Importing Products

The Products file contains 30 columns and items with an * are required (tblproducts.csv)

prod_key (int) *
– A unique number key starting with “1” and incrementing up. The first product will start with number “1” and move up from there. 

prod_name (varchar 100) *
– This is the display name that will show up on the sales page. The field can hold up to 100 characters however we recommend that you keep the names as short as possible (ideally under 15 characters)

prod_desc (mediumtext)
– This field can be skipped it is just an optional short description about each product. 

prod_cat (int) *
– The number here must reference the category that the product is lined under. So you can see on our example files that prod_key “1” Granola Bars is linked to prod_cat “1” from the tblcategory.csv file which is (Food)

prod_group (int)
– Product group is if items are linked together under one folder. For a basic import of items we recommend you leave this blank.

prod_status (varchar 100) *
– Product Status will be either “Active” or “Not Active” without the quotes. We recommend that you only import your Active products.  

prod_unit_price (float 10) *
– Price of the product. Needs to be in decimal format “2.50”

prod_qty_break (int)
– For basic import we suggest leaving this column blank. It refers to multiple product discounts and is the quantity at which the discount is applied

prod_qty_price (float 10)
– For basic import we suggest leaving this column blank. It refers to multiple product discounts and is the amount that will be discounted when the quantity in the cart is met. 

prod_tax_rate (float 10)
– If you are charging tax put the tax rate in. If you are not charging tax you can fill down each product with “0.0000″

prod_barcode (varchar 100) *
– This is the barcode for the product. If a product does not have a barcode you need to fill in a unique set of numbers and or letters without spaces. 

prod_track_inv (varchar 100)
– For each product you need to have a “Yes” or “No” for tracking inventory where Yes means you are tracking inventory. 

prod_display_main (varchar 50)
– This column is not currently being used, please leave blank.

prod_order (smallint)
– Within a category you can set the sort order. You can leave this blank or for each item put in a 1,2,3 where item number “1” will show first. 

prod_enforce_stu (varchar 10) *
– If the item has to be sold to a student (for example a student must be scanned in before selling the item) then put “Yes” If the item can be sold to anyone “No”

prod_public (tinyint)
– If the product is to be available for sale on the public portal put a “1” leave it blank if you are either not using the portal or the item is not to be sold on the public portal.

prod_gradelevels (varchar 255)
– This column is not currently being used, please leave blank.

prod_pickuptype (tinyint)
– If the item is for sale on the public portal and it will need to be picked up by the student in person set the value to “1”. If you are not using the portal or it does not need to be picked up, leave it blank. 

prod_reqagreement (tinyint)
– This feature allows you to have an agreement that the portal buyer must agree to before making a purchase. This is not commonly used so you can leave it blank. If you have an agreement you can put a “1” in this field and then on the next two items put the title and text for that agreement. 

prod_agreementtitle (varchar 255)
– Product agreement title is the title for the public portal purchase agreement. 

prod_agreementtext (mediumtext)
– Product agreement text is the body of the agreement for the public portal agreement . 

prod_displayhistory (tinyint)
– If you want to see the last time a student purchased this product you can set this to “1” otherwise leave it blank.

prod_purchased (int) *
– This is how we keep a quick lookup of total inventory. For purposes of upload, you will just need the total quantity in the prod_purchased column and the prod_inventory column. So if you have “100” items to start, put “100” in prod_purchased, “0” in prod_sold, “0” in prod_removed and 100 in prod_inventory.

prod_sold (int)
– Leave as a “0” for initial upload

prod_removed (int)
– Leave as a “0” for initial upload

prod_inventory (int)
– This number should match what the prod_purchased column has. 

prod_date_added (datetime)
– For the datetime it will be in the format 2021-10-29 12:02:03. For ease of import you can put just the current date and 00:00:00 for the time

prod_image (varchar 100)
– At this time we can not import images so please leave this blank.

prod_buy_with_spirit_points (tinyint)
– If the item can be purchased with spirit points put a “1” in the column. If it can not be purchased with spirit points put a “0” in the column. 

prod_number_spirit_points (decimal)
– If you have a one in the setting above put the number of points that the item can be purchased with here.