nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Imported Bulk items does not show buy, sell, selling price etc.

Eddies

I am trying to import a bulk list of products. I have copied a template, added details, saved accordingly as text and then completed the process but it is only showing the product name and number once uploaded. I have the buy and sell included but it doesnt show as selected, no prices, no GST details etc. I am so frustrated as ive been trying over and over and still the same. Ive tried in an example account as well as our actual business account. I have thousands of items I dont want to have to go into individually! And there are no contact details for MYOB anywhere. Help!

Find more posts tagged with

Accepted answers

Earl_HD

Hi @Eddies,

Thank you so much for your post and welcome to the Community Forum! I'm sorry to hear that you're facing difficulties with importing your product list. I really appreciate your patience and understanding about this issue, and I do apologize for the delayed response. This issue might be related to the format or structure of your template. To ensure a successful bulk import of products in MYOB, please consider the following steps:

* Template Format: Make sure that your CSV (text) file is correctly formatted. The columns in your file should match the fields in MYOB where you want to import the data. You can use MYOB's sample template as a reference.

* Data Mapping: During the import process, you need to map the columns in your CSV file to the corresponding fields. Double-check that you've mapped the "Buy" and "Sell" columns correctly and that all relevant fields are appropriately mapped.

* Data Validation: Ensure that the data in your CSV file is in the correct format. For example, prices should be in numerical format, and GST details should be accurate.

* Save as CSV: When you save your file, make sure it's in CSV (Comma-Separated Values) format. Other formats might not be compatible with MYOB.

* Test with a Subset: Before importing your entire product list, consider testing the process with a smaller subset of your data to identify any issues or errors more easily.

If you've followed these steps and are still experiencing difficulties, please do let us know for further assistance.
Regards,
Earl

All comments

Eddies

Hi Mike

I have just attached a text file of a few items i tried to import. I had tried just those few items alone and it had the same result as if I were importing the 1500 I need to put in at once.

The only error I have gotten now on those was that the item name was longer than 30 so the name was truncated (which is strange as I had saved them all as 30 characters in excel prior to saving as a note file). It just doesnt seem to be registering any other details than the item name and number. The buy and sell need to obviously register so that any costs can show up. When I go into the individual imported item afterwards I can see they are not ticked and when i tick them the costs imported still dont show up so they have not recorded in there so im assuming they are the columns that are the issue.

Book2.txt

Mike_James

Hi @Eddies , welcome to the forum. Are you able to post a few lines (with any headings) of the file you are trying to import? Change the product names if the information is confidential, because this is a public forum.

Also can you tell us what error messages you see in the log?

How many items are you importing at one time?