Retail

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!

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.

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 va

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 th

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.

Hoping someone else has a solution to an issue we’re having with customer tax exemption records and new locations We recently noticed that when a customer is setup with a Tax Exemption Number and Entity Usage Type those values are saved to their default customer location - However, when new customer locations are created, the values from the default location are not copied over to the new locationWe are using Avalara for a our tax provider and we have a BigCommerce store connected to both Avalara and Acuamtica - BigCommerce maintains a single Customer Tax Code (analogous to Entity Usage Type) at the customer record and all customer orders, regardless of address or location, are processed using this tax code and exemption. Acuamtica keeps this record at the location level and calculates only off the customer location values Because of the above, when a customer changes any of their shipping information online, the s

Hello - we recently implemented the Ecommerce edition to our existing distribution edition  to connect with our Shopify store.  We do not have any 3rd party integrations for calculating tax in Acumatica as most of our business runs B2B, so we manually set up Tax ID’s and zones and apply them whenever necessary.One area that we do have to charge taxes in via web sales.  For most states, we are only dealing with a single flat rate per state.  However, there are a few states, like California, where you are charging State + County + Local in some cases.Shopify handles this as 3 distinct API calls, as opposed to a single calculation of tax and a pass to Acumatica.I’ve tried to do some mapping to change all the incoming tax rate names from Shopify to match up with my associated rates in Acumatica, but with this being 3 calls in the example above, it seems like Acumatica wants to add 3 rows with the same Tax ID name, which it obviously can’t do/will error.I know

Does anyone have any experience connecting one Shopify Store to multiple different tenants in one Acumatica instance? Just checking to see if anyone has experience, Acumatica told me it was possible but working with someone who is experiencing some issues. Thanks for any input.

Hello, We’ve noticed when processing offline Shopify orders with cash that the log in Shopify shows the amount of cash paid and then the change given to the customer. When this order syncs into Acumatica, the payment total is the amount of cash the customer gave and doesn’t account for the change, leaving a balance on the payment. Is this a known bug, and is there a fix or workaround for this?   

I just learned that shopify for some reason does not support multi select dropdown out of the box.I’m interested in using the commerce connector to map Text, Combo and Multi Select Combo product attributes to Shopify metafields.I was recommended https://apps.shopify.com/metafields-editor-2. The Metafield Guru supposedly supports multi-select metafields.Does anyone recommendations/experience for syncing single and multi select stock item attributes in acumatica with shopify using the commerce connector?