Skip to main content

DMA: Create Products Using a CSV File

If you don't use a POS and would like to import your products with a CSV file, follow the steps in this article.

You may not have this option. If that is the case and you would like to use this functionality, contact your Deliverect account manager or our support team by selecting the chat icon at the bottom right of this page.

Getting started


Step 2. Open the downloaded file and start adding your products. While you can use the examples from the file as a guide, don't forget to remove them afterward. Also, try to fill out as many fields as possible, as this will save you from having to add anything manually afterward.

Do not delete the first row or change the order of the columns.

Check each section below on how to add different product types to your CSV file.

Products

Fields

  • PLU: The unique ID for the product. If left empty, one will be generated automatically at import

  • Name: The name to display in menus

  • Producttype: "PRODUCT" (all uppercase)

  • Description (not required): Describe the product

  • Price: In the format "00.00" (always use a period, never a comma)

  • TakeawayTax: Set the correct takeaway tax

  • EatInTax: Set the correct eat-in tax

  • DeliveryTax: Set the correct delivery tax

  • Imageurl: Provide the URL (address) of an image for your product

  • Subproducts: Set the PLUs of any modifier or upsell groups

  • Multiple(bundles): Leave empty

  • Max: "100" (always)

  • Min: "0" (always)

  • POSproductid: If you use a POS, set the PLU of the product

  • NutritionalInfo: Set nutritional information for the product

  • SupplementalInfo: Set nutritional information for the product

  • Packaging: Set packaging information for the product

  • BeverageInfo: Set beverage information for the product

  • ProductTags: Set product tags and allergens for the product

  • Calories: Set the calories for the product

Modifier groups

Fields

  • PLU: The unique ID for the modifier group. If left empty, one will be generated automatically at import

  • Name: The name to display in menus

  • Producttype: "MODIFIER_GROUP" (all uppercase)

  • Description (not required): Describe the modifier group

  • Price: "0" (always)

  • TakeawayTax: "0" (always)

  • EatInTax: "0" (always)

  • DeliveryTax: "0" (always)

  • Imageurl: Leave empty

  • Subproducts: Set the PLUs of the items to include.

  • Multiple(bundles): Enter the maximum amount of a modifier the customer can order

  • Max: How many modifiers a customer can add. Some examples:

    • A modifier group called "Extra sauce" contains five sauces that can be ordered, so the maximum is set to 5

    • A modifier group called "Choose your sauce" contains five sauces, but you want the customer to only choose one, so you set the maximum to 1

    • If a modifier group contains upsells, you can set the maximum number to be the total count of modifiers in the group

  • Min: This is the minimum amount of modifiers you can choose for this group. If you want the customer to order at least one modifier, you set it to 1. However, if the group contains upsells, you can set it to 0, because you do not want to force the customer into adding something optional to their order

  • POSproductid: If you use a POS, set the PLU of the modifier group

  • NutritionalInfo: Leave empty

  • SupplementalInfo: Leave empty

  • Packaging: Leave empty

  • BeverageInfo: Leave empty

  • ProductTags: Leave empty

  • Calories: Leave empty

Modifiers

Fields

  • PLU: The unique ID for the modifier. If left empty, one will be generated automatically at import

  • Name: The name to display in menus

  • Producttype: "MODIFIER" (all uppercase)

  • Description (not required): Describe the modifier

  • Price: In the format "00.00" (always use a period, never a comma)

  • TakeawayTax: Set the correct takeaway tax

  • EatInTax: Set the correct eat-in tax

  • DeliveryTax: Set the correct delivery tax

  • Imageurl: Provide the URL (address) of an image for your modifier

  • Subproducts: Set the PLUs of any modifier or upsell groups

  • Multiple(bundles): Leave empty

  • Max: "100" (always)

  • Min: "0" (always)

  • POSproductid: If you use a POS, set the PLU of the modifier

  • NutritionalInfo: Set nutritional information for the modifier

  • SupplementalInfo: Set nutritional information for the modifier

  • Packaging: Set packaging information for the modifier

  • BeverageInfo: Set beverage information for the modifier

  • ProductTags: Set product tags and allergens for the modifier

  • Calories: Set the calories for the modifier

Sections (for meal deals)

Fields

  • PLU: The unique ID for the section. If left empty, one will be generated automatically at import

  • Name: The name to display in menus

  • Producttype: "BUNDLE" (all uppercase)

  • Description (not required): Describe the section

  • Price: Leave empty

  • TakeawayTax: Set the correct takeaway tax

  • EatInTax: Set the correct eat-in tax

  • DeliveryTax: Set the correct delivery tax

  • Imageurl: Leave empty

  • Subproducts: Set the PLUs of the products.

  • Multiple(bundles): Enter the maximum amount the customer can order

  • Max: "100" (always)

  • Min: "0" (always)

  • POSproductid: If you use a POS, set the PLU of the section

  • NutritionalInfo: Leave empty

  • SupplementalInfo: Leave empty

  • Packaging: Leave empty

  • BeverageInfo: Leave empty

  • ProductTags: Leave empty

  • Calories: Leave empty

Importing your CSV file

Finished with your CSV file? Follow these steps to import it into Deliverect.

Step 1. Log in to your Deliverect account and navigate to the Products page.


Step 2. Select the button , then Import .


Step 3. Choose the Import CSV option.


Step 4. In the new window, select the Upload a file button to choose your file.


Step 5. Select the Upload button to start importing your products. This may take a few minutes to finish processing.

Attachment icon
Did this answer your question?