Minnesota Retail Delivery Fee

Minnesota Retail Delivery Fee

Topic: Minnesota Retail Delivery Fee
Version(s):  5.1
Editions: All

Please contact your accountant or the State of Minnesota with any questions

What is the Minnesota Retail Delivery Fee?

"Imposes the fee on each retailer equal to 50 cents on each transaction involving retail delivery in Minnesota that equals or exceeds the threshold amount. If the retailer collects the fee from the purchaser: (1) the retail delivery fee must be charged in addition to any other delivery fee; and (2) the retailer must show the total of the retail delivery fee and other delivery fees as separate items and distinct from the sales price and any other taxes or fees imposed on the retail delivery on the purchaser's receipt, invoice, or other bill of sale. The receipt, invoice, or other bill of sale must state the retail delivery fee as "road improvement and food delivery fee." The fee is imposed once per transaction regardless of the number of shipments necessary to deliver the items or of the number of items purchased. "

Read more using the link below:
  1. 2023-sut-legislative-bulletin.pdf (state.mn.us) page 5-7
  2. Tax Law Changes | Minnesota Department of Revenue (state.mn.us)

Making The Connection

Where Will I See This Within OLX?

This specific feature requires setup in the following areas:
  1. Base items
    1. Tax providers
    2. Product Offers
    3. Continuities
  2. Script Rules

What Reports Can Be Pulled?

  1. Inventory Item Association 
  2. Item List 
  3. Product Offer List
  4. Data Warehouse Export 

What Imports/Exports Relate to xxxx

  1. OLX Autoship Sequence Import Spec
  2. OLX Item Offer Import Spec

Trouble Shooting

  1. I created an offer but it's not showing when I try to setup the script rule

    1. Review the tax category on the base item for the offer you are looking for. 
      1. Default (OLX internal tax tables) = Delivery Fee (as Tax)
      2. If you use an external tax provider, make sure to check with the vendor to determine the correct category to use here. **You may require an update to your external tax providers tax tables within OLX

  2. The delivery fee is not creating on customer continuities

    1. Each required offer listed in the Per-Order tab will be added to each continuity order
      UNLESS…
      1. The offers product is tagged with the delivery fee tax category AND…
      2. The resulting total amount of the item (Unit Price+Shipping+Tax) is Zero
      3. If the aforementioned logic indicates that the item is not needed, it will not be included in the new
        continuity order

  3. How do I add the Delivery Fee to an order via Order Import or API Order Import?

    1. We have handled everything for you. There are no special settings that need to be taken into consideration when importing an order with the Delivery Fee. Just make sure:
      1. the offer name matches the offer setup in OLX
      2. the price is set to $0
      3. the shipping price is set to $0 
      4. tax value is added in the following fields:
        1. TAX_PROD##
        2. PAID_TAX_PROD##
        3. ORDER_STATE_SALES_TAX
        4. ORDER_TOTAL
    2. You will receive an acceptance message when an order is received with this offer attached:
      1. Fee as tax item detected (Delivery Fee). Skipped calculation and used provided tax for this item.
        ---------------------------------------------------------------------
        Orders in import file: 1
        Orders imported: 1
        Duplicate orders: 0
        New customers: 0
        Errors Encountered: 0

Setup

The base item must be created first, followed by the product offer, and global script rule. The fee can then be added to continuities already created in the system.

Base Item

It's important to remember that Base Items must be associated to one Client in the system. This means if your system handles multiple clients you will have to repeat these steps per client.
  1. Create your base item as you normally would (instructions can be found here). 
    1. It is not required but recommended to create a product group specific for Delivery Fees to help keep reports clean.
    2. It is also recommended to start with an underscore _ when naming the product group to be used for the Delivery Fees so that they will post at the top of the order entry screen.

  2.  Charge Only - check this box to move the item directly to Item Paid and skip the shipping process.
  3. To Check or Uncheck the Non Refundable box on the Options tab?
    1. "The fee is nonrefundable if any or all items purchased are returned to a retailer or if the retailer provides a refund or credit in the amount equal to or less than the purchase price. The fee must be refunded to the purchaser if the retail delivery is canceled by the purchaser, retailer, or delivery provider." 2023-sut-legislative-bulletin.pdf (state.mn.us)
  4. Navigate to the Tax Categories tab
    1. Set the Tax Provider
    2. Select the Category
      1. Default (OLX internal tax tables) = Delivery Fee (as Tax)
      2. If you use an external tax provider, make sure to check with the vendor to determine the correct category to use here.
        1. **You will need to notify OLX of the tax category to be used as you may require an update to your external tax providers tax tables within OLX
        2. New Minnesota retail delivery fee starts July 2024 - Avalara




Product Offer

  1. Create your product offer as you normally would (instructions can be found here). 
  2. Offer Name MUST = Road Improvement and Food Delivery Fee.
  3. Unit Price MUST = 0.00
  4. Shipping MUST = 0.00
  5. Rush Fee MUST = 0.00
  6. Select the Delivery Fee base item created above.


Continuity

New

When creating new continuities navigate to Per-Order Offers. Select the delivery fee offer created above and click Add. Save the Continuity Sequence Manager Popup.

Existing

When updating existing continuities, navigate to Per-Order Offers. Select the delivery fee offer created above and click Add. Check the box for Update existing customers. Click Yes or No to Please Confirm popup (will depend if other adjustments were made to the continuity in question - if only adding Delivery Fee you can select No). Save the Continuity Sequence Manager Popup.


Add Offer to Script/s

Don't forget to add the offer to the scripts for that client

Global Script Rule

  1. Set Rule Name
  2. Check box Use for order entry
  3. Check box Use for imports
  4. Action = Reject Order
  5. Client = None
  6. Error Memo - this is the message that will display to your agents during manual order entry
    1. example: The retail delivery fee is a state "road improvement and food delivery fee." The fee is imposed once per transaction regardless of the number of shipments necessary to deliver the items or of the number of items purchased. The fee is nonrefundable if any or all items purchased are returned to a retailer or if the retailer provides a refund or credit in the amount equal to or less than the purchase price. The fee must be refunded to the purchaser if the retail delivery is canceled by the purchaser, retailer, or delivery provider. 
  7. IF Condition = 
    1. Shipping Address Match
      1. Match Y/N = checked
      2. Address = *
      3. City = *
      4. State = MN
      5. County = *
      6. Zip = *
    2. Order Total Exceeds
      1. Amount = 100
  8. THEN Condition =
    1. Condition = Required Fee
    2. Product Offers = Road Improvement and Food Delivery Fee.
    3. Selected = checked
  9. From the Scripts tab you can select any or all scripts to add the Global Script Rule to


Attachments


    • Related Articles

    • Colorado Retail Delivery Fee

      Topic: Colorado Retail Delivery Fee Version(s): 5.1 Editions: All Please contact your accountant or the State of Colorado with any questions What is the Colorado Retail Delivery Fee? "Effective July 1, 2022, Colorado imposes a retail delivery fee on ...

    • Delivery Fee

      Topic: Delivery Fee Version(s): 5.1 Editions: All What Are Delivery Fees Delivery Fees are state required fees that must be added to an order. Some states, such as Colorado, require a specific naming convention to be used and allow districts within ...

    • Export delivery via sFTP, FTPS or FTP Failing

      Problems with firewalls and setup are the most common problems with export delivery. OLX v4.0 supports sFTP, FTPs and FTP. Please verify that you have submitted a Firewall Rule request to OrderLogix for the IP address of the FTP site. Please verify ...

    • System Preference: Expand Sales Agent Commission by Default

      When agents are viewing their Sales Commissions for a date range, it can become cumbersome for them to expand each order line to review the product specific details. If you wish to have all of the commission lines expanded automatically upon loading ...

    • Error in onStart:SMTP protocol error. 501 Syntax error in parameters or arguments

      Error in onStart():SMTP protocol error. 501 Syntax error in parameters or arguments This error can occur with email delivery of Process Alerts, Reports, Exports, etc. An error with parameters or arguments would indicate that there is something ...