logologo
Products
Ollie OrderOllie Ops
Solutions
B2B Order ManagementBrewery ManagementAgent / ImportSales Reporting
Industry
BreweriesWineriesDistilleriesCideries
Resources
Who uses OllieSupportBlog
Contact
Request Demo
Login   ➝
Growth
September 8, 2020

Britt Dzobia

Import all your orders from the top POS system in alcohol

Ollie Order has an importer tool that will make your weekly ordering task a breeze! 🍻

Our order importer tool is compatible with Barnet POS and Clear POS .csv export files.

To upload your .csv file with your orders, head to your Ollie Order Buyer portal and go to your Orders tab.

Click the Import Orders button in the top right-hand corner - you can either drag-and-drop your .csv file or you can click the Choose File option to find the file on your computer!

Press the Start Import button and Ollie will automatically pull all of the orders listed in your file πŸŽ‰

Once you click the Order Products button, the page will show you an itemized list of all the products you have successfully placed orders for.

Click on your Orders tab and you will see the orders populate by Supplier, listing each of the products you have ordered. It will also have an Imported tag on the order so that you can differentiate between orders you placed manually and those you uploaded from the importer tool. If you hover over this Imported tag, it will tell you which batch of uploads it came from and you can click the name to see the complete import list.

Important Notes:

βœ… Ollie Order Importer will only pull orders for suppliers that are currently using the Ollie Order platform, and will only allow you to order products that are active:

Screen_Shot_2020-07-16_at_2.01.19_PM.png

βœ… If you see the message Could not be found, such as the message on line 4 in the above screenshot, that means that either that supplier is not on Ollie Order, or that SKU is currently inactive. You can easily cross-reference this by opening up the .csv export file and matching up the line number from the upload page to the line number in the export file, as they correspond.

βœ… Even if some of your orders could not be found, you can still order all of the products that were successfully found in our system without editing and re-uploading the .csv. Just click the Order # Products button at the top of the page!

βœ… SKU number and quantity are the most important pieces of data for this import tool. You must at least have a SKU number, but if you do not have the quantity, Ollie will automatically pick the minimum order quantity for that product - i.e. 1 case of wine or 1 flat of beer.

βœ… If you have multiple entries of the same product SKU, it will combine the order quantities into one total.

Ollie TipπŸ’‘

If you are a Barnet POS user, you can create Customer Groups so that you can easily keep track of your suppliers that are on Ollie Order. That way, you can export their orders in a .csv separate to those suppliers who are not yet on Ollie, and therefore their orders will not be processed in our system.

From the POS Manager, go to CUSTOMERS >CUSTOMER GROUPS

You can create a group titled "Ollie Order" and add in your Ollie suppliers 😎

‍

Britt Dzobia

More from Ollie

Stop Now: update your pricing in 5 minutes

BC’s liquor industry is working hard to find silver linings to #2020. Temporary wholesale liquor pricing can be chalked up in the β€œwin” column. To take advantage of these pricing model changes, there are some things you need to know, and do so let’s get this done!

Britt Dzobia

Company

Get paid instantly and reduce your accounts receivable on order.Β 

Jesse Bannister

Company

Next Glass Acquires Canadian Alcohol Marketplace Company Ollie Order

Leading alcohol marketplace ordering technology platform to join the Next Glass family of brands

Jesse Bannister

Tech

How we protect and ensure your valuable payment data is secure

It's essential to protect your company's credit card data. So let's explore how Ollie works with Stripe to keep your payment data secure.

Jesse Bannister

Company

Craft Beverage Management Software

󰌻
󰈌
σ°‹Ύ
σ°•„
Products
󰐕
󰍴
Ollie OrderOllie Ops
Solutions
󰐕
󰍴
B2B Order ManagementBrewery ManagementAgent/ImportSales Reporting
Industry
󰐕
󰍴
BrewerieswineriesDistilleriesCideries
Resources
󰐕
󰍴
blog
Pages
󰐕
󰍴
ContactTermsPrivacy Policy
Get Started➝Learn More➝
Ollie Order Inc. Β I getollie.com