Skip to main content

Commerce 21R2 - Selling Made-to-Order, personalized products in Shopify or BigCommerce is now supported

Commerce 21R2 - Selling Made-to-Order, personalized products in Shopify or BigCommerce is now supported
josh.fischer
Semi-Pro II
Forum|alt.badge.img+1

In 21R2 the Retail-Commerce team has added support for selling personalized items on BigCommerce and Shopify then passing the personalization instructions into the Sales Order. This feature was requested by several existing customers and prospects. It was possible to accomplish in the past versions with customizations, but now it is much easier.

Here is how it works:

  1. On the eCommerce site you must configure the Made to Order item. 
  2. Within the ERP you must add a field within the Sales Order to accept this information. This requires a customization package. Below we are sharing a template to help you get started.
  3. You must use the entities window to map the eCommerce field to the Sales Order field you must use the entities window to map the fields

More details about each step are below.

 

Customization Package Template

Attached here is a template customization package. The template, when installed in 21R2, will add a column to the line items within the Sales Order window. The column header is "Personalization", but this can be easily updated in the package. Simply unpack the zip, open the XML file and update the text to the text you prefer.

  • DataField and FieldName - these represent the name of the field accepting data in Acumatica.
  • DisplayName - this is the text found in the column header within the Sales Order Window

 

 

BigCommerce - adding modifier options to products

BigCommerce Modifiers

Within BigCommerce this is done with modifiers. The BigCommerce modifiers accept strings, booleans or a selector or a multiple selector. Instructions for how to use modifiers - 

  • BigCommerce Docs on Modifiers - https://support.bigcommerce.com/s/article/Product-Options-v3?language=en_US#customizations


Shopify - adding line item properties

Shopify Line Item Properties - UI Element Designer

Within Shopify this is done with Line Item Properties. The Shopify Line Item Properties are a core feature of Shopify, however, the fields for accepting custom data are added on the theming layer.

Acumatica Entities Window

Once your fields are configured in eCommerce and the package is installed in Acumatica, you're ready to map the fields using the Commerce Entities window.

BigCommerce

Acumatica Commerce Entities Window - BigCommerce
  1. Go to Commerce > Entities
  2. Select your store
  3. Select the Sales Order Entity
  4. Ensure your on the Import Mapping tab
  5. Add a row
  6. Target Object: Sales Order > Details > Advanced
  7. Target Field: Transactions.UsrCustomText (update if you've changed the XML in the package)
  8. Source Object: Order Data > Order Product > Orders Products Options
  9. Source Field / Value: Monogram.value ("Monogram" here represents the name of the field label in BigCommerce)

Shopify

Acumatica Commerce Entities Window - Shopify
  1. Go to Commerce > Entities
  2. Select your store
  3. Select the Sales Order Entity
  4. Ensure your on the Import Mapping tab
  5. Add a row
  6. Target Object: Sales Order > Details > Advanced
  7. Target Field: Transactions.UsrCustomText (update if you've changed the XML in the package)
  8. Source Object: Order Data > Line Items > Properties
  9. Source Field / Value: Value
Did this topic help you find an answer to your question?

15 replies

Forum|alt.badge.img
  • Jr Varsity III
  • 67 replies
  • January 4, 2023

Hi @josh.fischer can I also use this way for an item having 6 dropdown (personalized)? Some dropdown has 15-20 options.

 

 


josh.fischer
Semi-Pro II
Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 70 replies
  • April 5, 2023

Hi @bernadeth58 - so sorry… missed this post till now. 

Great question and the quick answer is, “Yes”, you can technically add multiple “Choose Options” fields and each of those fields could have multiple options within them. 

Each of the option fields will will have their own ID, so when you are updating the customization package (to add the columns to the SO line items) you’ll need to account for all 6 of the customer “instructions” separately.

Curious how this worked out for you and if you have this working. Would love to see it in action.

Thank you! 

 


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

@josh.fischer , this is amazing. I’m going to use it shortly. Do you know if this will also support file attachments? In BigCommerce, we have a modifier called File Upload:

In case of embroidery, imprinting, etc., we set up BigCommerce to create a preview of the product customization, and we want to bring that into Acumatica, so that whoever is doing a customization would have a point of reference. It’s particularly important when we have more than 1 way or area of customization (say, front or back, top or bottom section, etc.).

Appreciate your response!


Forum|alt.badge.img
  • Freshman I
  • 21 replies
  • September 6, 2023

Hi @josh.fischer how can we get all the text from line properties to sync to Acumatica?
It only syncs the 1st line.

The text highlighted in yellow is what we need to see in Acumatica.


Here is what we see in Acumatica



​​​​​​​


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

@sams , I’m going to guess that _Color, _Drawer, etc. are all separate metafields. Which means you will have to map them all in the Entities screen, and concatenate for the Note Text field.


Forum|alt.badge.img
  • Freshman I
  • 21 replies
  • September 8, 2023

@Yuri Karpenko I am trying to see if I can see what the field names are in Shopify.

I don’t get any more options to map in Acumatica
 

 

There is no option for Order Data -. Line Item > Properties > Metafields.

 


Forum|alt.badge.img
  • Freshman I
  • 21 replies
  • September 8, 2023

@Yuri Karpenko If i do an export with a third party app I get it all in one cell.
 

 


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

@sams , I see now - it’s on the line level, not on the order level. I don’t know if you can get all of those values… You might need to customize the connector to cycle through all properties and add them to the ‘Value’. Right now, the connector is just taking the first property (0th element from the array).


Forum|alt.badge.img
  • Freshman I
  • 21 replies
  • September 8, 2023

@Yuri Karpenko That would be something I would need help with.


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

@sams , absolutely. Do you have a VAR you work with? They should be able to build a customization for you.


Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • 252 replies
  • April 9, 2024

Is there a way to map the export to update the line properties? 


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

@Jeff96 , yes, both, import and export scenarios can be used to update records in Acumatica. The only disadvantage of the export route is that your data will be static, while with import, you can use an Excel file to do the update.


Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • 252 replies
  • April 15, 2024
Yuri Karpenko wrote:

@Jeff96 , yes, both, import and export scenarios can be used to update records in Acumatica. The only disadvantage of the export route is that your data will be static, while with import, you can use an Excel file to do the update.

I meant export to Shopify updated line properties. I think you answered something else. 


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

@Jeff96 , yes I did answer something else :) That should be possible through a customization, not natively - at least, not yet.


Forum|alt.badge.img+3
  • Varsity I
  • 215 replies
  • April 16, 2024

do we have a compatible package for 23R2?


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