Skip to main content
Solved

Shopify Connector: Last Cost vs Current Cost


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 92 replies

Hey Folks,
Couldn’t find much on this, so wanted to see if anyone had any thoughts:

In template item creation, under the “matrix item” tab, it is picking up the “last cost” and it seems to push this to Shopify as the product cost even though the item has a ‘current’ cost defined under the Stock Item:

 

These particular items have a “Current Cost” but not a “Last Cost”: 

 

Do we happen to know why the Shopify Connector uses the Last Cost and not Current?  Are we supposed to be updating the cost to “last cost” routinely?

Cheers,

k2

Best answer by simonliang91

@K2a , @Yuri Karpenko , @michael73 , @brendan91 , @freddydelrio39 , @lawsont , I posted a “How To” article for export cost to Shopify.
 

 

View original
Did this topic help you find an answer to your question?

17 replies

brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • February 27, 2023

Our company does not use current cost. The availability of this data depends on your company’s chosen cost calculation method. We primarily use the average cost field, but last cost is used by everyone, so I image that is why they chose that field.

 

Have you tried to manually change which field to map to Shopify in the entities screen?

 

 


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 92 replies
  • February 27, 2023
brendan91 wrote:

Our company does not use current cost. The availability of this data depends on your company’s chosen cost calculation method. We primarily use the average cost field, but last cost is used by everyone, so I image that is why they chose that field.

 

Have you tried to manually change which field to map to Shopify in the entities screen?

 

 

interesting theory.  I did look at the stock item entity mapping and there is no “Target” field for Cost, unless I’m missing something. 

We use standard costing, is there a way to sync last cost and current cost?


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • February 27, 2023

I took a look at the json on the Shopify product page, and cost was not an available field to populate even though that field is available in the UI on the product screen. Apparently the cost field is updated through inventory processing rather than the product processing which is why we can’t edit the cost field in entities under stock items which is connected to product processing.

I suppose we could create a product request to allow us to edit that data transfer? This would allow us to map the cost field of our choosing back to Shopify.


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 92 replies
  • February 27, 2023
brendan91 wrote:

I took a look at the json on the Shopify product page, and cost was not an available field to populate even though that field is available in the UI on the product screen. Apparently the cost field is updated through inventory processing rather than the product processing which is why we can’t edit the cost field in entities under stock items which is connected to product processing.

I suppose we could create a product request to allow us to edit that data transfer? This would allow us to map the cost field of our choosing back to Shopify.

Thanks for taking a look!  We can also create Metafields and populate them, so I’ll look into seeing if we can use that avenue for an additional attribute...


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • March 20, 2023

Hi @K2a  were you able to find a solution? Thank you!


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 92 replies
  • March 21, 2023

I opened a ticket with ACU working through it now. 


Forum|alt.badge.img
  • Jr Varsity III
  • 49 replies
  • April 28, 2023

Any progress on this? We need to populate Shopify variant cost so the Ecomm team can run their reports.

 

Thanks!


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 92 replies
  • April 28, 2023
michael73 wrote:

Any progress on this? We need to populate Shopify variant cost so the Ecomm team can run their reports.

 

Thanks!

ACU has it as “Development in Progress”….  


Forum|alt.badge.img
  • Jr Varsity III
  • 55 replies
  • January 16, 2024

I was led to believe that it was not possible to push the cost to Shopify from Acumatica. Are we able to? Is there a how-to article someone can share or point me to the right screen/steps? Thanks! 


simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 76 replies
  • January 17, 2024

@lawsont and @K2a , which Acumatica version are you using?

Shopify doesn’t have a cost field in Product or Product variant API, the cost field is in the InventoryItem API only. We don’t use InventoryItem API in product entity, so you cannot push the cost to Shopify currently.

But if you want to implement it through a customization package, it’s possible to do that in 2023r2, I will write a How-to article later to introduce the steps. 

 


Forum|alt.badge.img
  • Jr Varsity III
  • 55 replies
  • January 17, 2024

@simonliang91 We are on 23R1 planning to upgrade to R2 soon. I’d definitely be interested in that customization package and any steps you can provide. Thanks!


K2a
Jr Varsity III
Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 92 replies
  • January 17, 2024
lawsont wrote:

@simonliang91 We are on 23R1 planning to upgrade to R2 soon. I’d definitely be interested in that customization package and any steps you can provide. Thanks!

We are also 23R1, but we typically upgrade 1x per year to the R1...so 24R1 will be our next upgrade.   Very interested in your your “how-to”!  


Cheers


Forum|alt.badge.img

@simonliang91 Please tag me on this customization/How To post when you post it. Thanks!


Yuri Karpenko
Captain II
Forum|alt.badge.img+6
  • Captain II
  • 356 replies
  • February 13, 2024

@simonliang91 , @K2a , I think it is important to keep in mind that any of these 4 fields might be desirable as a source of data:

 

The first 2 are appropriate when STANDARD costing is used, while the bottom 2 are appropriate for Average, FIFO, and Specific costing methods.

So, @simonliang91 , if you’re thinking of exposing these values in the Entities screen, under the Product Availability object, it also makes sense to expose the costing method, so a formula could be built by a user as to which value to use, depending on the costing method for each inventory item.

In addition, it would be good to provide guidance on the non-stock items, since even though they are not part of the Product Availability sync, they also have a cost, and that cost can be complicated:

 


simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 76 replies
  • February 14, 2024

@Yuri Karpenko , the customization package will base on Product entity only, when you export the product item to Shopify, the cost info will be exported as well. In the Product Availability entity, we don’t fetch the cost info from ERP.


simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 76 replies
  • Answer
  • February 14, 2024

@K2a , @Yuri Karpenko , @michael73 , @brendan91 , @freddydelrio39 , @lawsont , I posted a “How To” article for export cost to Shopify.
 

 


Forum|alt.badge.img+1
  • Semi-Pro I
  • 177 replies
  • May 17, 2024

@simonliang91 Thanks for sharing the Customization.

I take it from the whole conversation that the Cost for normal Items is not synced either and we would need to customize it?

This just seems like a huge miss from the native Product.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings