---
title: Importing Products
description: "A detailed guide on how to create and import a product list. This is specifically going over how to import with \"Import Products and Inventory, Create ALL Products Present\" as the chosen method from the import dropdown selection menu. 1.…"
url: "https://acadiapos.com/doc/importing-products/"
updated: "2026-04-09"
category: Inventory / Products
---

# Importing Products

A detailed guide on how to create and import a product list. This is specifically going over how to import with "Import Products and Inventory, Create ALL Products Present" as the chosen method from the import dropdown selection menu.

1. Open google docs (Preferred, can use another doc program if you wish)

**These instructions are for Google DOCS**

Go to row 1 and name the first column **sku**

Go to row 2 and name the first column **name**

Go to row 3 and name the first column **price**

Go to row 4 and name the first column **cost**

Go to row 5 and name the first column **category**

Go to row 6 and name the first column **vendor**

Go to row 7 and name the first column **size**

Go to row 8 and name the first column **qty**

Go to row 9 and name the first column **caseqty**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/1e834df0-4e22-40ad-981b-71772e32105d/user_cropped_screenshot_0bafefbb393041cf8e58550b1ebc3db3_text_export.jpeg?w=780&ssl=1)

2. **TIP:** To add another attribute

**Step 1.** Right click on the columns letter. (If you look above an attribute like name, you will see a letter in its own cell.

**Step 2.** Look in the menu list and choose whether it gets placed to the left or right of the that column you selected.

**Other additional attributes you can add. (see the final slide for full list)**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/2a460f41-d524-41d4-9db2-9ccf3985d75b/user_cropped_screenshot_3fdef0799e634453accc5e54284a74a6_text_export.jpeg?w=780&ssl=1)

3. Fill in all the information for each row to manually enter the products.

You can also import your previous product list (if you have one) into google docs and replace the attribute names if you need to, every system has its own terminology.

4. After filling out the document with your products, go to the top right corner and click "**File"** and then go down to download and click on **"Comma Separated Values" (It will download to your default/set download folder)**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/d4244266-c901-4ee9-8a8c-3d65f943d2f7/user_cropped_screenshot_0ba50b6dea5c4daf8e2510d06027448f_text_export.jpeg?w=780&ssl=1)

5. This is the file in the download area, you can move it to another folder to organize things easier.

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/a29bbe18-04c2-4109-9fba-f4dc7f9b972b/user_cropped_screenshot_9a020a5c7c294c90a4bd00233fd31afa_text_export.jpeg?w=780&ssl=1)

6. Navigate to [manage.acadiapos.com](https://manage.acadiapos.com/) for **Retail** and [rfsm.acadiapos.com](https://rfsm.acadiapos.com/) for **Restaurant**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/908a1f02-4daa-45ea-9014-541afaa82363/screenshot_0c72ce6dd3d447daaa2468c02e8782ef_text_export.jpeg?w=780&ssl=1)

7. Click **"Items"** on the sidebar

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/23dcc520-5132-4acf-9d05-e7731febe83c/user_cropped_screenshot_d3863db7d59740629b03d5fba9974856_text_export.jpeg?w=780&ssl=1)

8. Click **Import/Export** in the upper right corner

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/a8b40a86-ab12-4063-96af-8c0af791332a/user_cropped_screenshot_7f30b4f57294482f9fbff22bcec97500_text_export.jpeg?w=780&ssl=1)

9. Select **"Import Products and Inventory, Create ALL Products Present"**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/4c35fdba-41f3-4d37-9133-b9961b1f9d3f/user_cropped_screenshot_b6869fb744aa4b4c99676797cba569f0_text_export.jpeg?w=780&ssl=1)

10. Select the product list you create and click **"Save"**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/06e06a94-6327-47dd-ad29-354810da48aa/user_cropped_screenshot_bd6415e7fbd64114b5ed9867a9caf24d_text_export.jpeg?w=780&ssl=1)

11. Click **"Import"**

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/2c8a3651-8363-4df9-b19d-b211f7789d30/user_cropped_screenshot_deda39f81a474234967163c66560ccef_text_export.jpeg?w=780&ssl=1)

12. Look at the end result of the product import

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/afbcf8f9-8924-484c-8d88-6fb44c989cc6/user_cropped_screenshot_f8336f0be5ed4c6db0c04c7086cca658_text_export.jpeg?w=780&ssl=1)

13. The import was successful

If you click on the 4 squares to the left of the blue pen, you can view the **QTY/PRICE/COST** and see that everything imported correctly.

You can also adjust other details in this area as well.

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/ec11f8d0-eb57-4f72-8d47-90e8543e9404/user_cropped_screenshot_b49b2ccd1a45422ea74169929ad6ce46_text_export.jpeg?w=780&ssl=1)

14. In one of the products, the **QTY** was changed to **100.** It has reflected successfully, as well as the **PRICE** and **COST**.

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/b09029d2-b78a-4b2a-b35c-7fda2601db17/screenshot_f5649783026746a7bb21e692ab489c52_text_export.jpeg?w=780&ssl=1)

15. If you **click on the blue pen** that is to the right of the 4 squares, you will be able to pull up the product view/edit, you can also see the case quantities also imported correctly at 100.

![](https://i0.wp.com/colony-recorder.s3.amazonaws.com/files/2026-02-27/2e4ab661-b0b1-42ae-93b8-c1cb3d8e23c3/user_cropped_screenshot_d0ccdaf48c364ca898bd596299aa49ff_text_export.jpeg?w=780&ssl=1)

**Common attributes with definitions**

- **sku:** Stock Keeping Unit; a unique internal code used to track an item.
- **name:** The title or label of the product.
- **price:** The amount the customer pays for the item.
- **cost:** The amount your business paid to acquire or make the item.
- **category:** The department or grouping the item belongs to (e.g., "Beverages").
- **vendor:** The supplier, manufacturer, or brand you buy the item from.

**Additional Attributes**

- **barcode** (1-7) (You can add up to 7 additional barcodes): The scannable code on the product, usually a UPC or EAN.
- **low_stock_qty**: The inventory threshold that triggers a low-stock warning to reorder.
- **last_sales_7** / **30** / **60**: The total number of units sold over the last 7, 30, and 60 days, respectively.
- **modifier groups**: Customization options for the item (e.g., "Toppings" or "Add-ons").
- **disable_discount**: A rule that prevents any coupons or promotions from being applied to this item.
- **kitchen_name**: A shortened or specific name used on tickets sent to the kitchen printer or display.
- **pos_status**: Determines whether the item is active and visible on your physical store's POS registers.
- **web_status**: Determines whether the item is active and visible on your e-commerce site.
- **weight**: The physical weight of the item, typically used to calculate shipping costs.
- **age_verify**: A flag that prompts the cashier to check the customer's ID (e.g., for alcohol or tobacco).
- **size:** The physical dimensions, apparel size, or portion size of the item.
- **customer_notes:** Specific information, descriptions, or instructions that may print on the customer's receipt.
- **qty:** The current number of individual units you have in stock.
- **variant_option_one_name:** The category of a product's first variation (e.g., "Color").
- **variant_option_one_value:** The specific choice for that variation (e.g., "Red").
- **case_qty** (also case qty, caseqty, case quantity, case_quantity, casequantity): The number of individual units contained within a single bulk box or case purchased from the vendor.

##### Full List of Fields

Please note that custom attributes must be added prior to import for the information to imported correctly.

- sku
- name
- price
- cost
- category
- vendor
- barcode 1,
- low_stock_qty
- last_sales_7
- last_sales_30
- last_sales_60
- modifier groups
- disable_discount
- kitchen_name
- pos_status
- web_status
- weight
- age_verify,size
- customer_notes
- qty
- variant_option_one_name
- variant_option_one_value
- case_qty
- case qty
- caseqty
- case quantity
- case_quantity
- casequantity