Forum Discussion

PrimeProducts's avatar
1 year ago

Importing food order directly into invoicing

Hi, I run a food retail and wholesale business and receive orders via excel. How do I import those excel orders into MYOB so that I can automatically generate invoices instead of manually creating each invoice. 

The excel order uses the same Item names as listed in MYOB.  Thanks in advance,

PP

1 Reply

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    1 year ago

    Hi PrimeProducts , there are several ways to go about this in AccountRight:

    • manual import using the import/export wizard. For this to work, your orders file need to have columns to match MYOB's requirements. The best start point is to export some existing sales orders/invoices, with all columns, and align your excel order file and data to match. (Customer names need to match MYOB). Then save the excel file as a txt file (tab-delimited would be my preference) and try a manual import. Backups before importing are vital, until you get used to the process.
      There is a big learning curve with manual imports, but if it works, it's a free solution.

    • Second option is to try using an add-on program like Transpost (transpost.com.au), which is a clever program to streamline the import process. Orders would be posted via the API to your MYOB file. There would be a charge for this program.

    • Third option is to have a developer like us write a custom import program using your excel file as is. Orders would be posted via the API. This option is probably more expensive but very tailored. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.