Skip to main content

NetSuite to Shopify Item Cost

Comments

15 comments

  • Mike Meyer

    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.

    1
  • Sree Vani Amara Senior Product Manager

    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. 

    -1
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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.

    0
  • Hairball.io
    Celigo University Level 4: Legendary
    Salesforce-NetSuite IA Certification
    Engaged

    Hey! It is possible! See the screenshots... Use the same Saved Search you use for Inventory.

    Email me at pabloHairball.io if any questions

    2
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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!!

    1
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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?

    1
  • Mike Meyer

    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!

     

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    Mike Meyer

    Have you tried it without the "inventoryItem"? When I did it I get this:

    0
  • Mike Meyer

    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:

    0
  • Mike Meyer

    Hairball.io

    It looks like you created a standalone flow for updating item cost, can you confirm that that's how you did this?

    0
  • Sree Vani Amara Senior Product Manager

    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. 

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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.

    1
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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!!

    1
  • Mike Meyer

    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 :)

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    Mike Meyer

    Good call on the backdating on running the flow... Glad the fix worked for you even though it shouldn't - LOL

    0

Please sign in to leave a comment.