Skip to main content
Solved

Add Export Mapping To Shopify Entity

A
Jr Varsity II
Forum|alt.badge.img

Hello,

I am Trying to find where/how to add a new “ERP Field / Value” to the BC202000 screen. We would like to be able to push an attribute with the “ERP Object => Template Items → Matrix” like we are able to with the “Template Items → attributes”.

Or we would like to be able to push a custom field on a matrix item so we can push our UPCs to Shopify.

 

How can I add custom fields to this dropdown?

I’ve been looking through the PX.Commerce.Shopify source, but as far as I can find it pulls the values out of the ether.

Thanks in advance!

Best answer by Yuri Karpenko

@AidenMission , UPC exists on the matrix item level (child of a template item), and is stored in the Cross-References tab, when one of the line is set up with type Barcode.  If you fill out those values for your matrix inventory, they will flow into Shopify’s product variants.  The idea is that each variant can (and probably should) have a separate UPC, since a variant represent a distinct product.

Hope this helps.

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

13 replies

Yuri Karpenko
Captain II
Forum|alt.badge.img+6
  • Yuri Karpenko
  • Captain II
  • 375 replies
  • Answer
  • October 4, 2023

@AidenMission , UPC exists on the matrix item level (child of a template item), and is stored in the Cross-References tab, when one of the line is set up with type Barcode.  If you fill out those values for your matrix inventory, they will flow into Shopify’s product variants.  The idea is that each variant can (and probably should) have a separate UPC, since a variant represent a distinct product.

Hope this helps.

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
StevenRatner
Chris Hackett
A
3 people like this
  • StevenRatner
    StevenRatner
  • Chris Hackett
    Chris Hackett
  • A
    AidenMission
A
Jr Varsity II
Forum|alt.badge.img
  • AidenMission
  • Author
  • Jr Varsity II
  • 25 replies
  • October 4, 2023

Thanks @Yuri Karpenko, that makes sense to me, but I have added the value to the cross reference and it is still not flowing in. Is there somewhere else that I need to configure the system? I have also removed the old export mapping so that should not be an issue.

 

UPDATE:
I tested this on a lone stock item (one not part of a template) and it did push the barcode through, so I am unsure as to why it is failing for the child inventory items.

Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@AidenMission , hmm..  I just tried it with these settings:

 

And Shopify received the UPC correctly:

 

The only other thought I have is, make sure that your Stock Items mapping on the Entities screen doesn’t redefine UPC mapping in any way, since I believe that matrix items use Stock / Non-Stock Item mapping.

LMK how it goes.  Thanks!

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
StacieJurczak41
A
3 people like this
  • Chris Hackett
    Chris Hackett
  • StacieJurczak41
    StacieJurczak41
  • A
    AidenMission
A
Jr Varsity II
Forum|alt.badge.img
  • AidenMission
  • Author
  • Jr Varsity II
  • 25 replies
  • October 9, 2023

Thank you @Yuri Karpenko, I’ve checked and I don’t have I don’t have any mappings overwriting it for stock or nonstock items. I also spun up my test server and tried with no customizations and it did not work either. So, I have opened a case with our VAR and we are working on it. If we find out what it is I will announce it here in case someone else is having a similar issue.

Yuri Karpenko
Chris Hackett
2 people like this
  • Yuri Karpenko
    Yuri Karpenko
  • Chris Hackett
    Chris Hackett
K
Freshman I
Forum|alt.badge.img
  • KEL
  • Freshman I
  • 20 replies
  • October 11, 2023

I am having the same issue. Template items not sending the UPC up to Shopify.

A
1 person likes this
  • A
    AidenMission
Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@KEL , your best course of action would be to open a case with Acumatica.  @AidenMission , did you have any updates yet?

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
A
2 people like this
  • Chris Hackett
    Chris Hackett
  • A
    AidenMission
A
Jr Varsity II
Forum|alt.badge.img
  • AidenMission
  • Author
  • Jr Varsity II
  • 25 replies
  • October 13, 2023

@Yuri Karpenko What version was your Acumatica instance on? I was just informed by our VAR, “The Core Shopify connector does not currently support barcode mapping for matrix items and that they plan to include this feature in 2023R2” They then gave me a case number. So I do not know how you were able to push the barcodes. @KEL you probably want to see that as well. 

I am just going to deal with this manually as it comes up and wait until we do an update at a later time.

Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@AidenMission , @KEL , I did my test on the 22R1 (22.114.0029). 

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
A
Jr Varsity II
Forum|alt.badge.img
  • AidenMission
  • Author
  • Jr Varsity II
  • 25 replies
  • October 13, 2023

@Yuri Karpenko, interesting I am on 23R1 23.111.0019. There must’ve been a regression. 

K
Freshman I
Forum|alt.badge.img
  • KEL
  • Freshman I
  • 20 replies
  • October 16, 2023
AidenMission wrote:

@Yuri Karpenko What version was your Acumatica instance on? I was just informed by our VAR, “The Core Shopify connector does not currently support barcode mapping for matrix items and that they plan to include this feature in 2023R2” They then gave me a case number. So I do not know how you were able to push the barcodes. @KEL you probably want to see that as well. 

I am just going to deal with this manually as it comes up and wait until we do an update at a later time.

we were on 2022R1 and the UPCs were uploading to Shopify only when we upgraded to 2023R1 did we notice the UPCs no longer populating.

I do have a ticket in and they stated the same thing to me. I am waiting back for a response to my question about why we had it and now we don’t.

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
K
Freshman I
Forum|alt.badge.img
  • KEL
  • Freshman I
  • 20 replies
  • November 6, 2023
Yuri Karpenko wrote:

@AidenMission , UPC exists on the matrix item level (child of a template item), and is stored in the Cross-References tab, when one of the line is set up with type Barcode.  If you fill out those values for your matrix inventory, they will flow into Shopify’s product variants.  The idea is that each variant can (and probably should) have a separate UPC, since a variant represent a distinct product.

Hope this helps.

This was working until we updated to 2023R1 then all of our template item variants are no longer getting the barcode sent up to Shopify.

 

M
Semi-Pro II
Forum|alt.badge.img
  • mikeho
  • Semi-Pro II
  • 228 replies
  • November 16, 2023

This is extremely important for us as well - we just recently upgraded to 23R1 and are experiencing the same issue.

Does anyone know anything new regarding this? Is there a workaround to sync UPCs to Shopify if you’re using Template/Matrix items?

K
1 person likes this
K
Freshman I
Forum|alt.badge.img
  • KEL
  • Freshman I
  • 20 replies
  • November 16, 2023
mikeho wrote:

This is extremely important for us as well - we just recently upgraded to 23R1 and are experiencing the same issue.

Does anyone know anything new regarding this? Is there a workaround to sync UPCs to Shopify if you’re using Template/Matrix items?

I have had to manually copy them over. 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved