Retail

When exporting orders from Acumatica using the Shopify connector, it is requiring that the sale be > 0.   Error on order : Transactions is invalid; Error on transactions : Amount must be greater than zero for sale transactions We use Acumatica to create replacement orders, giveaways, affiliate orders that have no revenue. Acumatica makes it easy to use Reason Code, plus it’s quicker to order from Acumatica than Shopify. We would like these orders to be in Shopify so the customer can see the history and so our 3PL can fulfill those orders using our current workflow.  Has anyone experience this or know of a work around, other than creating the order in Shopify.   

Hi! I'm using the shopify connector to sync template items from Acumatica to Shopify. I know I can sync the template item and matrix item at once by just syncing the template item but I added an image URL on the matrix item under Media URLs but it's not syncing the image when I sync the template.

Has anyone tried using a custom field as an additional filter in the Sales Order entity of the Shopify connector?A post from two years ago mentioned that this functionality would be supported beginning with version 21R2. We are currently on version 24R2. 

Hey everyone! Our web team has had a handful of sales orders fail to upload to Acumatica with the error of :Aggregate Validation: PX.Objects.SO.SOOrderSite+lineCntr I’m not sure how to dive into if this is a customization issue. I have an VA that we can ask but was hoping to see if maybe this was an known issue in the community first :)Thanks!

Recently upgraded to 25R1 and noticed two new errors when syncing Template items that we didn't come across during our sandbox tests.1. "At least one option value is duplicated." 2. “Error mapping types... Input Destination Member: Options” We’re encountering this issue frequently, but there’s no clear pattern or apparent cause. Some template items sync successfully, while others, seemingly identical in structure, fail with the same error.The issue occurs with both new and existing template items, regardless of whether they have one or multiple attributes. We've seen it affect items with just two matrix variants, even when those variants have only a single attribute (e.g., color). After thoroughly reviewing each item, we’ve confirmed that there are no duplicate attributes across variants that would justify this error, particularly since many of these items have been in the system for a long time without issue.Is anyone else experiencing this? Any insights or suggestions would be apprec

We have been testing the BigCommerce B2B customization on Acumatica 23R1 ahead of launching our BigC store, and we have seen a lot of issues with it. I was wondering if others have run into these problems and have a way of dealing with it or even just a better way of thinking about these problems so that we can live with them.We find it confusing that the main contact rather than the primary contact (except for the primary contact name) is used as the first admin info in BigC and don’t know how to treat the primary contact in Acumatica to make this less confusing. We also find it confusing that the 2nd rather than the 1st main contact phone number is synced to BigC. We don’t know how to handle the possibility of a customer deleting the first admin in their company in BigCommerce B2B since that is how the connector is connecting the customer in Acumatica to the company in BigC. We have noticed many, many issues with modifying existing customer data in either Acumatica or BigC. The data

I’d like to make a processing screen that will allow me to add items to the grid of items to process.I’m basically trying to make a grid that you can run processing on that I can add/delete items.  The only filter I have is at the top of the form that is a checkbox that changes the grid from “Show Posted”, “Show Unposted”.  The filter checkbox pulls data from a custom table, so it is a “real filter”  I want to be able to add items to the grid, and THEN process them.  I also want to be able to import items into the grid.From all the things I can see, processing screens are designed to pull data for the grid that already exists in the system and are not editable.  I’ve tried a plethora of things to try to get the grid on my processing screen editable with no luck.At this point, I created a Form/Grid screen and put “manual” processing buttons on it to process my grid items, but I want to be able to show the typical processing screen where it shows the Successful, Warnings, Failed etc.  I

In this topic, I want to share how to create a customization to export matrix item cost info to Shopify product variant. This customization can work well on 2023R2.Create a customization project Create a new code file, and extend the Graph from “PX.Commerce.Shopify.SPTemplateItemProcessor”.     Select the “OVERRIDE METHOD” from the menu, and then select the Method “SaveBucketExport” from the list.      Modify the code as below. Create the new instance of ProductRestDataProvider and InventoryItemRestDataProvider object Use the ProductRestDataProvider instance to get the existing Product/Product variant info from Shopify, cost info doesn’t save in Product variant object, it’s in the InventoryItem object, so we need to get the InventoryItemId from the variant object. We save the variant mapping info(ExternID is Product variant ID, LocalID is the Matrix item NoteID) in BCSyncDetails, so we can find the associated Matrix item by NoteID. All matrix items are saved in Bucket.Product.Local

Does anyone else need to connect to Markettime to get Sales Orders into Acumatica? We are currently using Syncware to connect Markettime to Acumatica, but are not happy. Is there another option to get Sales Orders that outside, field reps write in Markettime into Acumatica? Looking forward to any suggestions or advice from the community!

We are currently testing the new B2B features of 23R2.In Shopify, using the “Payment Due Later” checkbox and setting Payment Terms doesn’t seem to matter when the order is pulled into Acumatica. The order will sync with Payment attached as a Check & the Financial terms set to Prepayment- see below. Is this the expected behavior? $0.00 paid by customer, Terms set to Net 30: Order in Acumatica with terms shown as Prepayment: Order in Acumatica with full Payment applied: 

Hello! We are required to import Sales Orders from the Shopify site, but we are not required to create Payments on Acumatica through Shopify and create payments manually at the end of the month comparing the statement. Will it be possible to import only the Sales Orders and will there be any impact on not importing the payments? Thank you in advance!Amanda

Can someone help me figure out why this SO is showing multiple lines for the same item? Usually when this happens it’s because ACU is needing to pull from a different location or use multiple lot numbers but as far as I can tell the line details are all the same :)  

Hey folks, has anyone seen this issue -  Some orders in Shopify are being ‘fulfilled and unfulfilled’ by the connector ‘via manual’: We’re not sure how this ‘via Manual’ cancelation is occurring, but it seems to subsequently impact if a RC order is created or not. Any viz on this one out there? This is version 24r116 and we’re using the Webhook Subscription version 2024-07 (probably needs an update). 

The region setting in the Shopify connector for Acumatica is set to French, and the default language in Shopify is also French. When I sync a template item from Acumatica to Shopify, the product title appears in French as expected. However, the variant option titles show up in English, even though both English and French versions are present in Acumatica. Why is this happening? If I create an order in Acumatica and receive a deposit from the customer, once after I send the order details to Shopify, can i collect the remaining balance from the customer through Shopify, for example by sending them a payment link via Shopify?  We’re using 2024R2—does it support 2000 variants, or is that feature only available in 25R1?Thank you! 

Does anyone know if it is possible to sync related items under a product in Acumatica to a single, list-type metafield?Example:Product A has Products B and C selected as Related items in Acumatica.  Product B and Product C are synced together to a single list metafield as “Product B, Product C” (or something along those lines). Later, Product C is removed as a related item in Acumatica and replaced by Product D. Now, Product B and Product D are synced together to the single list metafield.

Does anyone have experience with Markets Pro in Shopify?   It is supposed to allow us to bring in sales from other countries (CAD for example), however it looks like it brings it in with the Currency of the foreign country, and fails for us because we do not have MultiCurrency enabled. I was hoping it would perform the conversion of the currency and import as USD.    It seems the JSON file contains the USD amount and the conversion: Are we supposed to MAP this in the connector?!Cheers,k2

Hi everyone! I wanted to share some thoughts about the challenges we’ve faced with syncing Template-Matrix items as Product-with-Variants in Shopify. As many of you know, we’ve run into a couple of limitations:Shopify can only support 3 options. There’s a cap of 100 variants per product.The first limitation has already been addressed in a previous discussion here. However, our Template item has 4 options and nearly 4,000 variants, which has been quite a challenge.We’ve tried breaking down the Template items into new ones with 3 options, but we’re still hitting the second limitation with some Template items exceeding 100 variants.The really exciting news is that Shopify has recently announced their new GraphQL product APIs, which now support up to 2,000 variants! 🎉 This is a game changer for us and anyone facing similar issues.I’m curious to know: when can we expect to see this new capability available in the Acumatica-Shopify connector? Any insights would be greatly appreciated!Thanks

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 w

When a new matrix item is synced to Shopify, the Variant Option Name defaults to “Title”.Is there a way in Acumatica to change the Variant Option Name to something else?

Hello,While adding new products to Shopify(template items), we kept getting errors on some of the metafields syncing to Shopify.We getting getting errors like:Error on type : 'single_line_text_field' must be consistent with the definition's type: 'list.single_line_text_field'.;Error on type : 'single_line_text_field' must be consistent with the definition's type: 'multi_line_text_field'.;Error on type : 'single_line_text_field' must be consistent with the definition's type: 'metaobject_reference'.;Existing products are syncing just fine(and their metafields), in fact I can copy the values from the non-working product and push a sync on an existing product and it sync just fine.But if I do the opposite and take the values from a working product and copy them to the non-working, it gives the same errors.I also cloned one of the existing working template items(that i confirmed I could resync) and when I tried to sync the clone, I get the errors on the metafields again.It really seems like

I want to add a tag to Shopify orders with the dropship PO Number from the line details in Acumatica. I see the “mark for PO” field, but not the PO Number field. 

Hi Team,We are working with Build 23.112.0032 and working on a customization where we have to add an image url ( https://xyz.s3.amazonaws.com/kkltQWuXULPcHQ6TmoMsZkiJOK93x8.png) as File attachment to a Sales Order record through code. We tried to insert this image url under Name field in UploadFile table and later to map this record along with Sales Order NoteID under NoteDoc table but we are facing issue with approach. Can you please suggest the best possible way to achieve this. Thank you in advance! 

Is there a way to mark a stock item to not accept parts to be “Returned” to inventory and “Non-Refundable” if a customer (and salesperson) try to create an RC?We sell custom made parts that we don’t want to accept any parts to be returned to inventory for credit. 

We are trying to sync modifier options from BigCommerce to Acumatica. However, when the modifier type is ‘dropdown’ the value that syncs over to Acumatica does not match BigCommerce.  If we have the modifier type set to a text field, then the value syncs over just fine. but we need it to be a dropdown option, and would appreciate any insight into how to get the value to sync over correctly

Hi Guys,I need help to sync Line Item properties to Acumatica. Shopify apparently stores the variant options in and array format. Default connector only syncs the 1st option from line item properties but it could have up to 10+ options in that field.Is there a way we can create a loop to loop through the array and show all the options in Acumatica? Thanks for your help.