Retail

Is there a way to have Acumatica sales order numbers match the Shopify Order Number during sync? Would make it much easier for customers to reference one order number instead of multiple.

We are updating our products and would like to remove large groups of stock items from their associated template IDs, modify the Item Class and Template Items, and then re-attach the stock items to their updated TemplateIDs.  We understand how to associate products to the template IDs, but cannot determine how to delete the Template IDs from each Stock Item to remove them from their templates. We have tried setting the value of the Template ID = NULL, = (nothing) , and =String.Empty .  Does anyone have some pointers on how to remove these via import scenario? Patrick 

In the current Shopify connector, it doesn’t support the custom mapping in the Entity mapping screen for the Refund entity, but if you want to have some custom mappings in the Refund order, you can do it in the customization project. In this topic, I want to share how to create a custom mapping in Shopify refund entity through the customization package. You can make a mapping to the original field or custom field. I tested it in 2023R2 and it works well. Create a new customization project Create a new code file, and extend the Graph from SPRefundsProcessor.     Override the method CreateRefundOrders     public class SPRefundsProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPRefundsProcessor> { public static bool IsActive() => CommerceFeaturesHelper.ShopifyConnector; #region Event Handlers public delegate Task CreateRefundOrdersDelegate(SPRefundsBucket bucket, MappedRefunds existing, CancellationToken cancellationToken); [PXOverride] public Task CreateRefundO

Hi,I am trying to figure out a way to make cases that are being created by incoming emails automatically be assigned to to certain case classes based on rules. I only see how to assign them to different employees in the organization, not how to create a map for case classes. I appreciate the help! 

I have several Sales Orders from Shopify that failed to sync >5 times. Now in aborted status. Can’t work out how to sync them manually. I tried moving one Set as Prepared, which returned it to Failed Status. Then tried to Sync it from there. Same error – “The status of the #### order does not allow modifications. Please synchronize records manually.” What is the correct manual method?Gillian  

I have 4 store locations in Acumatica and Shopify. I want to sync “AVAILABLE” stock quantity from Acumatica to Shopify.This is the export settings in the connector, where the availability mode is set to AVAILABLE. Stock quantity in Acumatica:After syncing stock quantity to Shopify: As you can see “AVAILABLE FOR SHIPMENT” quantity is synced instead of “AVAILABLE”. What am I missing here to make it work? Thank you!

After pushing images from acumatica to Shopify, I deleted the image in shopify to test a re-sync. It failed to push out the image and gives me the following.   After that I can’t get the images to resynch correctly even with a full prepare and process. It there a way correct this? also how are others managing multiple images with matrix items and variants? 

Hi Acumatica Community,We are using the Prepare Physical Count screen (ScreenId=IN504000) to manually generate physical count documents every day. Currently, we use a specific Physical Inventory Type with a predefined list of items and warehouse filter.Our goal is to automate the process by scheduling the system to generate a physical inventory document every day at 2:00 AM, using a specific Type ID.My questions are: Is there a supported way to do this with Automation Schedules, Business Events? Can this be done using a custom import scenario, API, or customization project? Are there best practices or samples from other implementations? Any insights or guidance would be highly appreciated.Thank you! 

I can find a lot of information about gateways, but not any about hardware. Anyone have advice? 

Want to share with you the way to handle Made-To-Order Products with BigCommerce Connector.Made-To-Order products are special types of products where each item may have a specific unique attributes like text, or painting, or style. I will show you an example of gift spoons with special graving. Step 1: We have we need to create a new Stock-Item that will represent the spoon in Acumatica.For testing purpose you can receive a couple of spoons on your warehouse using the Inventory Receipts form (IN301000). Step 2: Prepare and Export Stock Items to your BigCommerce instance. If you manage images/availability in Acumatica, you should also Prepare and Export Availability and Images entities. Step 3: Since Acumatica-BigCommerce Connector cannot manage Product Modifiers, we should go and configure Made-To-Order product in BigCommerce directly. There we want to create Product Modifier Options with allowed values and combinations. For my spoon, I want to allow 2 fields: Message Font and Message

Use Case: Users would like to sell in Commerce sites the same product in different UOMs than the default Sales UOM in Acumatica. Example, merchant could sell apples in Kilogram(KG) and also in Pounds(LBS). In Acumatica, the user could have the Sales UOM as LBS but sells in Commerce site as KG. Most of the sites do not support UOM. Both Shopify and BigCommerce does not support it. Solution: Provide the SKU code of the product in Commerce site in the Cross-Reference tab in the Alternate ID field with the required UOM in the Stock/Non-Stock forms in Acumatica. Commerce Connector, will get the SKU code from the Commerce site’s sales order product and checks in Acumatica if there is a matching Inventory ID, if it finds, then it will be used with this UOM in Acumatica SO Line. If not, connector will check the Alternate ID from the Cross-Reference tab with Alternate Type as Global. If it matches, then the UOM will be taken from the cross reference tab for the SO Line. Please see below screens

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

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.