Retail

I noticed this behavior as of at least 24R2. When you map a field in Acumatica to be a custom field in BigC, the connector will create the custom field in BigC only if that field has a value in Acumatica. Previously when we were on 23R1, if you deleted the text from the field in Acumatica, on the next sync, the custom field would be deleted in BigCommerce. Now as of 24R2, previously created custom fields are not being deleted from BigCommerce when they are given an empty value in Acumatica. Instead the custom fields in BigC retain the last value that was in Acumatica before it was deleted. This seems like a bug to me and is very inconvenient for us. Has anyone else experienced this and found a solution?

We have a situation where we have companies created in Acumatica from Shopify then when the customers associated with those companies get created in Acumatica, they are not linked what so ever.  For Shopify B2b capabilities how is AR to be handled when it should be at the company level and not the customer level in Acumatica?  Terms orders

Hello!I’m required to integrate an external bar code system to Acumatica. Is there any guide or help on the steps that needs to be followed to integrate?Thank You!

Is there a way to sync stock items already in Acumatica with Shopify SKU’s without creating duplicate item numbers in either system? Using Acumatica Shopify Connector

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    

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!

We are using the Shopify Connector, and have the Shopify Warehouses mapped to Acumatica Warehouses. Whether I select a Location for the mapping or leave it blank, it seems to ignore anything <UNASSIGNED> regardless of Allocated or not. This is not ideal because it reports a higher inventory number than is actually available to be sold, resulting in over-selling, upset customers, etc.  Am I missing something?

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

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 t

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 thos

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 d

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, W

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

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!