Importing orders from online store to Zoho as Sales Orders

Wondering what the best practice for this is... I need inventory tracking.

This is my current workflow:

Check to see if customer exists in Zoho. If not, create contact. Grab the customer_id.

Then add the line items to the sale order. However, this is where I am running into trouble.

I need to use the item_id when creating the sales order, but I have no easy way to retrieve this. First of all, the List Items call doesn't have a query for SKU, so I would have to use name and I can't guarantee that my online store and Zoho items share the same name. Secondly, if I have to use an API call to find every items individually I am going to blow through my daily API calls in no time.

There must be an easier way, if I could use the SKU field when creating the sales order and have Zoho match the fields for me that would be great. SKU is already guaranteed to exist and be unique.

The SKU field isn't even present on the sales order line item?! I feel like I must be missing something.

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
matt
bootad

Sticky Posts
Zoho Inventory will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Inventory will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than
Zoho Finance Workshop 2023 is coming to the USA. Meet the experts, get exclusive training on Zoho Finance apps and more.
Hello all, We'd like to invite you to our biggest Zoho Finance workshop in the United States. After a brief break, we are excited to be back. This year, we're bringing together our customers and community members for two days of curated hands-on sessions,
Celebrating our Zoho Community SuperBuds
The SuperBud program recognizes the efforts Zoho users put in to help the rest of the community thrive and grow in their individual Zoho journeys. Be it the ZUG meetups or these forums, several Zoho users including our MVPs andZUG leaders, have stepped
Authtoken Deprecation for Zoho Inventory APIs
UPDATE (7 July 2021): We've extended the deadline to 30 August 2021 for converting Authtokens to OAuth. Hello everyone, The usage of Authtokens to authenticate API calls is being deprecated on 30 August 2021 across Zoho's Finance suite of products,
ZOHO Inventory - Early Access
https://twitter.com/zoho/status/646715717849493504