Love's Integration: import Love's fuel prices into OpenRoad TMS

Modified on Fri, 20 Nov at 10:01 AM

Connect Love's to OpenRoad TMS and your Love's fuel price files are imported automatically. The prices appear on the Daily Prices page and on the Love's fuel stops of the fuel locations map, so your planners can pick fuel stops by price.

Who can do this: only users with the Super Admin role can open the Loves page in Settings. The price import also needs the Love's daily prices feature to be switched on for your account. If the page or the prices do not work for you, contact OpenRoad Support at help@openroadtms.com.

Before you begin

  • Ask your Love's representative for SFTP delivery of your daily fuel price file for your OpenRoad TMS integration. You need the SFTP host, username, password and the folder where the files are placed.
  • Your Love's fuel stops must exist in your account. A price is saved only for a stop that is already in your account. Upload them with Upload on the Fuel Locations page (an .xlsx or .xls file with Source set to Loves). OpenRoad also refreshes the Love's store list every day for accounts that had Love's fuel card transactions in the last week.
Important
never post your SFTP password in chat messages or tickets that other people can see.

Part 1: Connect Love's

  1. Go to Settings → Integrations → Loves.
  2. In the Configuration card set Integration Status to Enabled.
  3. Fill in Host and Username (both required) and Password. In Folder enter the folder where Love's places your files (the default is /incoming).
  4. Choose the Load Map Fuel Price: Default Formula or Target Pricing (see "Which price is shown").
  5. Click Save Settings and confirm Save changes? with Save.

Once a password is saved, OpenRoad never shows it again. If you leave the field blank when saving, the saved password stays. If you change the Host or the Username, enter the password again.

Note
this page has no Test Connection button, and enabling the integration does not check the connection. After saving, check that prices arrive (see Part 3).

Part 2: How the import works

  • OpenRoad checks your Love's SFTP folder every hour, 10 minutes after the hour.
  • Every .csv file in the folder is imported and then removed from the SFTP folder.
  • A file with a name that was already imported for your account is not imported again. For best results give each file a unique name.
  • The date of the prices is read from the file. Each row is matched to a Love's stop in your account by store number. A row with no matching stop is skipped, and the file is marked as partly imported (this is not shown on screen).

Which price is shown

  • Default Formula. The price is your price from the file minus the state fuel tax rate of the stop's state (the IFTA rate in effect on the price date). If OpenRoad has no IFTA rate for that state, it uses the tax figure in the file, and otherwise zero. If the file has no price for a stop, no price is shown.
  • Target Pricing. The price is the target price from the file, shown as received. If a stop has no usable target price, OpenRoad shows the Default Formula price for that stop. A target price is usable when it is a positive number.

Part 3: See your prices

  1. Open Fuel, Daily Prices. The menu item appears after the first prices have been imported. The table lists each site with its provider, city, state, your price, the target price and the effective date, and opens on today's date.
  2. Open Fuel, Fuel Locations, Map View. A Love's stop with a price dated today shows Fuel Price Today in its pop-up, and Fuel Price Tomorrow when tomorrow's price is already imported. See Fuel Locations page.

Love's prices are not fuel transactions, so they do not appear on the Fuel Transactions page.

Upload a file by hand

If a file did not arrive, a user with the upload permission can click Upload on the Daily Prices page, choose the file and set Source to Love's. Love's files must be .csv. A file with a name that was already uploaded for this source is rejected.

Frequently asked questions

Where do I see the prices?
On Fuel, Daily Prices, and on the Love's stops of the fuel locations map. They are not on the Fuel Transactions page.
A stop shows no price. Why?
The stop is not in your account (add it with Upload on Fuel Locations), or the file has no price for it, or the price is not dated today.
Can I use Pilot and Love's at the same time?
Yes. Each has its own settings page and its own credentials.
OpenRoad shows no error when something goes wrong. How do I know?
Errors are not shown on screen. If prices stop arriving, check that Integration Status is Enabled and that the host, folder, username and password are still correct with Love's.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article