Skip to main content
Solved

Change default mapping for shopifys "Variant Name"

  • May 8, 2025
  • 3 replies
  • 84 views

Forum|alt.badge.img

I want to try something and im curious if anyone has tried this.

 

We are using shopify plus and I am having a very hard time importing matrix items into acumatica.

 

The complications I'm having is i don't want to break up my items into separate item classes for now, I simply have 1 item class for stock items and i have about 50 “Variant” attributes for this item class. But the problem is when i try creating matrix items it requires me to inactivate all attributes I'm not using on each template item, which is very annoying and complicated with an import scenario.

 

Here is what I'm thinking to do to simplify. Since i’m never looking to have more than 3 variant types anyway (shopify limit), i want to create only 3 “variant” attributes lets say Varient1, Varient2, & Varient3 and add a regular (non varient) text field attribute right above each variant so lets say Varient1Name, etc. And have this replace the default mapping to shopify for the variant name.

 

Anyone tried this or know if it will work?

Best answer by Yuri Karpenko

@Jonathanr , do you really need to have your products synced between Acumatica and Shopify? Do you want your products in Acumatica to be Matrix Items?

You could export products from Shopify into a CSV file, and then import them into Acumatica through an import scenario.

3 replies

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

@Jonathanr , it won’t work. I just did a massive data transfer between Shopify and Acumatica - product with variants. I had to employ a number of custom scripts (through API) to create those products in Acumatica.


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 8, 2025

Any other workarounds to achieve this, maybe directly in shopify to rename them?


Yuri Karpenko
Captain II
Forum|alt.badge.img+6
  • Captain II
  • Answer
  • May 8, 2025

@Jonathanr , do you really need to have your products synced between Acumatica and Shopify? Do you want your products in Acumatica to be Matrix Items?

You could export products from Shopify into a CSV file, and then import them into Acumatica through an import scenario.