Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
D
david-theorigina
November 28, 2021
Question

Trying to update some standing data on existing products. Run the import and half failed. Seems to be the Quantity As At date. No date is acceptable. Ideas?

  • November 28, 2021
  • 1 reply
  • 3 views
This is QBO

1 reply

Kristine Mae
Kristine MaeModerator
Moderator
November 28, 2021

Let's get the products imported, David-theorigina.

 

We'll have to ensure the date format is correct. Our program accepts format like this: MM/DD/YYYY or DD/MM/YYYY. 

 

You may want to check the spreadsheet again and check the format. Also, ensure the info is correct. The field indicates the start date of the inventory item.

 

I'll add this reference to guide you better with import the list: Import products and services into QuickBooks Online.

 

Feel free to get back to this thread if you need more help. We'll reply as soon as we can. Take care!

 

D
david-theoriginaAuthor
November 29, 2021

There were no dates in any of the lines. Half were accepted, half failed. On the failed screen I used the calendar to specify a date. I tried today, yesterday, tomorrow, a year ago, the end of the year. None worked. It can't be the date format as the calendar doesn't work either. 

S
SarahannC
Level 9
November 29, 2021

Hello there, @david-theorigina.

 

I appreciate the time and effort you exhaust to update your existing products properly.

 

Let's make sure that the date you've entered is the start date when you create an inventory item. The inventory as of date is the date you start tracking the quantity on hand of an inventory item in QuickBooks. The Quantity as-of Date field can be applied to an inventory item.

 

Still, you can follow the suggestion shared by my colleague above. If the same thing happens, we can open your QBO account in a private window or incognito mode. From there, you can import the products into your QBO account. 

 

You can use any of these keyboard shortcuts to access one: 

 

  • Ctrl + Shift + N for Google Chrome
  • Ctrl + Shift + P for Mozilla Firefox and Microsoft Edge
  • Command + Shift + N for Safari

 

 If it works, go back to the regular browser and clear its cache. Alternatively, you can also use other supported browsers. 

 

Please let us know how it goes. The Community is always around if you need further assistance, david-theorigina.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement