Skip to main content
Question

Line.SalesItemLineDetail.ItemRef

  • November 3, 2020
  • 3 replies
  • 848 views

I am trying to import orders shipped from Ship station and or Amazon to Quick Book Online Advance. When ever I added the SKU to the Product/Service field it keeps giving me this error :

Line.SalesItemLineDetail.ItemRef

I have tested my SKU and it works manually and is inventory.

 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • November 7, 2020

Hey! It looks like your line item reference doesn’t exist in Quickbooks. Have you checked that the Item Code you’re sending via Zapier exists in your Quickbooks? If it doesn’t, it normally throws this error.


  • Author
  • Beginner
  • 1 reply
  • November 10, 2020

Well Zapier is looking for a product number that can't be seen in Amazon is only QBO internal for the matching.

 


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • January 5, 2021

Hi @QBOuser!

 

As you’ve mentioned, you need to use the QuickBooks product code rather than the Amazon name. There are a couple of different ways that you could find this to use in the Zap.

I think that the easiest would be to add a QuickBooks Find Product(s) search step before the Create Sales Receipt step. That would search for the product in QuickBooks based on the name of the product (as it’s coming from Amazon) and will then give you a product code that you can use in the Create Sales Receipt step. 

 

I hope that helps!