NetSuite to Shopify Item Cost
Does anyone have a reliable way to map the individual Item Cost from NetSuite to Shopify? I have both Matrix and Individual products for this application.
1
Does anyone have a reliable way to map the individual Item Cost from NetSuite to Shopify? I have both Matrix and Individual products for this application.
Comments
Gabe, were you ever able to get this working? I am looking to do the same thing.
The Shopify API documentation seemed to hint at importing cost via the inventory update API. I tried including a column for cost in my item inventory export saved search, and mapping it in the Netsuite to Shopify inventory flow but had no luck.
Hi Mike, We have a flow to sync the products along with their price from NetSuite to Shopify - https://docs.celigo.com/hc/en-us/articles/228220687.
You can also refer to Shopify API documentation for products.
Hope this helps.
Mike
The answer is no. There still isn't a way to map the cost over to Shopify. If you look at a product in Shopify and put ".json" at the end of the URL you will see there is no "Cost" or "Cost per item" field visible. This is likely due to Shopify not providing access to that endpoint.
So it's not a Celigo issue - it's a Shopify issue.
Hey! It is possible! See the screenshots... Use the same Saved Search you use for Inventory.
Email me at pabloHairball.io if any questions
Mike Meyer
I think I just figured it out!!!! Looks like the Celigo and Shopify API are not communicating with accurate returns from Shopify on the available fields. I will put in a ticket for it and see what they say.
In the interim - try this: Map your "Cost" field you set up from the NetSuite Saved Search and in the Integrator Mapping for Product or Matrix Items manually enter "product.variants[*].cost" and hit preview - I am going to test it on my end as well.
Here's a link on the Shopify side showing the "cost" data: https://shopify.dev/api/admin-rest/2022-01/resources/inventoryitem#top
Like I said, I just added the "product.variants[*]." to the "cost" and hit preview - and it showed up in the Preview!!
Hairball.io
I found a different way of doing it as well after digging back in. I like your method too - wonder if one method is better than the other to use?
Gabe Parr I noticed that API documentation and tried adding it to my inventory flow but without luck. Then I tried something similar to you, based on the structure in that documentation. I mapped my Cost column to product.variants[*].inventoryItem.cost and the preview json looks the same as compared to the API documentation. However, my cost was not imported after running the flow and checking on an updated item.
Hairball.io I will try your method next and update how it goes!
Mike Meyer
Have you tried it without the "inventoryItem"? When I did it I get this:
Gabe Parr
I initially tried product.cost, but I never tried product.variants[*].cost. I'll give it a go - but that does not match API documentation from Shopify. Curious if you verified that the costs actually import correctly like this? Here's how the documentation looks:
Hairball.io
It looks like you created a standalone flow for updating item cost, can you confirm that that's how you did this?
I apologise , I misunderstood the request as mapping price . Cost is part of Inventory Item API and inventory flow is utilising inventory levels API. Both inventory and product flows won't be able to support cost. As suggested by Hairball.io , you can try a custom flow to sync cost.
Mike Meyer Sree Vani Amara Hairball.io
Can confirm - the change I made to the mapping works as I set up! Just modified the record in NetSuite because we are running Delta on the flow and POOF! There's the Cost!!!! No extra flow is required...
SWEEEEET!!
Well sort of - now I just have to do a minor update to 12K products so the flow can see modification date change for all of them.
Mike Meyer Sree Vani Amara Hairball.io
Can also confirm the change works on child items for Matrix Flow as well!!
Yeesh - now on to modifying 12K products!! WHeeeeee!!
Gabe Parr
Cheers!! This works perfectly, even though according to documentation it probably shouldn't - lol.
If you want to leave your products flow as a delta flow, you could probably just set a custom date for the flow and push it back to something like 1/1/2000. Might save you a headache in NS :)
Mike Meyer
Good call on the backdating on running the flow... Glad the fix worked for you even though it shouldn't - LOL
Please sign in to leave a comment.