Retail

I frequently receive inquires about the details of how payments are handled between eCommerce platforms and Acumatica. Below are details about this topic. Common eCommerce Merchant ProfilesWe see 2 primary types of Merchants who are selling via eCommerce and managing their back office via Acumatica.B2C/D2C Merchants Often, individual orders are small. B2C/D2C merchants rarely sell items which cost more than $2k Most Consumer purchases are done with a CC Sometimes merchants allow buyers to place an order, pickup/pay in store B2B Merchants Orders are typically larger Common to see orders which total at $5k - $30k Some buyers want to use CC for payment, or it's a requirement of the seller Many buyers will prefer to pay by check via NET30/NET45 Terms Rule of Thumb - best to not

Hi All, Not sure if anyone can help (Even just to confirm).  We have setup the acumiatica with BigCommerce conector. For the most part it has all been tedious but there seems to be a short fall in the amount of attributes you can/not sync from acumatica to Big Commerce. ONe specific that comes to mind is the matrix/variant attributes. Specifically we wanted to send across the matrix products width, depth and height AS per acumatica: There doesnt seem to be any defaults for anything of these. Thanks,,Ben.  

I am having trouble controlling sales of different matrix items. We sell both on Shopify and enter order directly in Acumatica, so the item status field is important when we need to shut off sales. Most of our items are set up at template items, each template has different package sizes. We often have to set the item status to “No Sales” when we are sold out of a package size.When we have to turn off multiple matrix items under the template, it often times fails in the sync to Shopify saying “No matrix items are generated”. This is turn does nothing on Shopify and will allow sales to come down on items we are sold out of.Has anyone else experienced this issue with the ecommerce connector? Ideally we want to have template items so we can have multiple options on one product page, but we want to control each matrix item like it is a single stock item.

Any developers here? Do you know the logic of Ship Via import from BigCommerce in 23R1?We have this weird scenario, where if an order has a shipping method in BC that is not mapped on the BigCommerce Stores > Shipping Methods screen, Acumatica will not throw an error on import, but will use a UPSGROUND shipping method.We used to have a formula in Sales Orders entities screen for Ship Via, like this:=iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Ground')<>-1,'UPSGROUND',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Standard')<>-1,'UPSSTD',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Early')<>-1,'UPSNDAAM',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], '2nd Day Air')<>-1,'UPS2Day',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Next Day Air')<>-1,'UPSNDA',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Expr

I am experiencing a new issue with our Acumatica/Shopify connector. Our company has created many template items in Acumatica, each having multiple matrix items. We did this so we could sync products to Shopify and create one product page, with multiple matrix items (variant options on Shopify) on that one page. However in some cases the matrix items are missing from Shopify even though the template and the matrix items are all active with inventory available. We have a schedule running on the product availability entity to run every 10 min. I get this error in the sync history screen. Hoping someone on here has had a similar experience or can point out what I may be doing wrong.  

How do we set up Big Commerce to sync the correct salesperson bidirectionally? If the salesperson is changed on either platform, we need them to mirror each other. I can’t find it in the sync mapping, and it doesn’t seem to do it on it’s own through the customer syncing.

Is there a preferred method for adding a restocking fee to an RC return order? Our thought was to create a “RESTOCKFEE” non-stock item and add it to the RC with a negative amount to subtract the fee from the return. Does this make sense, or is there a better way to go about this?

Not sure what this one is about… I tried clearing sync data for this Entity and Preparing + Processing again but the same Error occurs. 

This is a unique encounter in our system. On the bigcommerce side (where the orders are created) the customer purchased 14 different products upon syncing on Acumatica only the 13 products are in the SO because of that the total is different. Note: All products in the list are already synced and active.Error Message: The status of the SC014658 order does not allow modifications. Please synchronize records manually. What do you think is the problem?

We have an entity that is not using Acumatica. When we sell product to this entity we sell it at our cost (Unit Price). Currently when we create a new Sales Order for this entity we have to manually update the Unit Price for every line on the sales order. These sales orders usually has a large number of lines, which adds significant time to the process.Also we are using Average Costing so the Unit Cost can change when a new PO is received. This means adding special pricing for this entity in the Sales Price form is not realistic.Is there a way based on the Sales Order Customer to pull the Unit Cost into the Unit Price field?Thank you!

We are having an issue with the online sales orders. In our specific case, our Main warehouse is “01” and our Online warehouse is “10”. In Acumatica, all inventory items have “01” as the Default Warehouse. In the BC Connector we are syncing data only from warehouse “10” (Warehouse Mode: Specific – “10”). .  All incoming BC orders are defaulting to the Default Warehouse and not the Specific Warehouse in the connector.  We must manually change the warehouse from “01” to “10” on all online orders. High demand products are oversold because Acumatica is not “subtracting” inventory from the correct warehouse.We need to somehow “force” all incoming BC orders to pull inventory from warehouse “10”.Anybody knows how could this been done with configuration? 

In our Shopify connector we get this error code on the customer entity that reads “Error on phone: Phone number already been taken.” Or it will read “Error on phone: Enter a valid phone number.” It prevents the customer record from syncing to Shopify, and will also prevent a new sales order for a given customer to sync into Acumatica. It seems like the system is doing some sort of validation on the phone number field on the customer, this is the field on the general tab under the additional account info section.  

Is there any way to sync the current effective Sales Price for a product over to Shopify instead of the Default Price?

We are attempting to sync Template/Matrix items from Acumatica to BigCommerce.   This is the error message we are seeing on the Sync processing“At least two values of the attribute XYZ have the same description. Specify a unique description for each attribute value, and process the record again”I am assuming this is an impact because of the Attribute option description :.But is the connector triggering off of Descriptions at the Attribute level even though the Matrix Combination itself is unique: Any assistance on thoughts here would be extremely helpful.  

Hi there, we have a customization where we have overridden the GetBucketForImport method in BCSalesOrderProcessor.cs graph. After overridden we are facing issue at await keyword.Please refer the below screenshots and code.Overridden code: public delegate Task<EntityStatus> GetBucketForImportDelegate(BCSalesOrderBucket bucket, BCSyncStatus syncstatus, CancellationToken cancellationToken); [PXOverride] public async Task<EntityStatus> GetBucketForImport(BCSalesOrderBucket bucket, BCSyncStatus syncstatus, CancellationToken cancellationToken, GetBucketForImportDelegate baseMethod) { OrderData data = await orderDataProvider.GetByID(syncstatus.ExternID); if (data == null) return EntityStatus.N

I have two different prices for my sales through Acumatica and Shopify at the moment. To change the price of products in Shopify I manually changed it in the Shopify website. The problem occurs when I sync a stock item in  Acumatica the price automatically changes in the Shopify store. Is there a method I could use to ensure that when I change the price in Acumatica it doesn’t affect my prices in the Shopify store.Thank you in advance for your valuable insights and assistance.

We have a unique use case with RC Refunds imported from Shopify. We have setup a customization to require the sales person fields in Sales Order documents, this policy cannot be changed. It is creating an issue with Shopify Refunds because there is no import mapping available for the Refund entity. We get an error because the default sales person field cannot be empty. Same issue with Sales Orders, but we used import mapping with Shopify Sales Orders to default the salesperson to “WEB” for all imported Shopify orders. The only way for us to update a Shopify sales order as returned/refunded is to Return/Refund in Shopify and import to Acumatica, from what I understand. Therefore we need a customization until import mapping is available for the Refund entity. I figured if we have a unique return order type (copy of the RC type) for Shopify returns then we could add a script to the Sales Order entry screen to automatically update the Default Sa

I have a client who has a need for items that are refurbished to be priced differently in Big Commerce and Acumatica.Ideally, the item would be a pencil and if the pencil was sharpened, it would have the same SKU but be priced lower based on a location in a warehouse. Does anyone have an idea on how to achieve this?I’m pretty sure it’s a limitation with Big Commerce but couldn’t hurt to ask with so many smarter than me here! 😁

Hi!Recently, BigCommerce announced their new BOPIS functionality out of the box and I’m wondering if entities to connect to this feature is in the Acumatica roadmap. Does anyone know something about it? Greetings everyone!

If so, what credit card readers are you using at the POS counters?We had ordered Ingenico Lane 3000 devices and they connect fine to eBiz, but after talking to eBiz support, they are not supported for the Acumatica POS (aka Heuristic).  Support told us they only support 1Retail.  Credit Card capture (aka EMV) seems like it should be easily cross-functional, but apparently not.  Can anyone recommend a EMV device that works well with Acumatica POS?

We’ve recently had a lot of Digital Agencies reaching out to us and asking questions about our solution, our eCommerce connectors and requesting more resources to learn the solution. From my perspective, this is terrific! I think Digital Agencies will love what we’ve built, because we’ve considered their ability to learn, deploy and even modify our connector technology to meet the needs of complex customers. I’m a big fan of Digital Agencies and Digital Native Brands who have engineers (or simply “tech people”) on staff who like to roll up their sleeves and learn new tech. I decided I should assemble a list of resources and share here. Few things to know:Anyone can spin up Acumatica locally. We are a SaaS application, however we also offer versions of Acumatica that you can spin up locally or on a webserver (AWS or Digital Ocean, for instance).  We offer a “trial” version of Acumatica

Hello!I wanted to get some help with some code in the commerce connector. My client has a Shopify store with a connection to Amazon. All Amazon orders display a Tag of ‘Amazon’ in the Shopify Order Tags along with a few other tags that are autogenerated. I’m trying to import ‘Amazon’ to one of the Acumatica SO fields anytime ‘Amazon’ appears as a tag and leave the field blank if it does not. Here’s what I have some far, which worked once, but does not seem to work everytime.=IIf(InStr([OrderData.Tags], 'Amazon') >0, 'Amazon', ' ')Thanks in advance!

Hey all, New commerce sync error for us related to “Shopify.API.REST.OrderCancelReason”. Looks like it errors out when staff provides some generic reason for cancellation in Shopify.   Error converting value "staff" to type 'System.Nullable`1[PX.Commerce.Shopify.API.REST.OrderCancelReason]'. Path 'order.cancel_reason', line 1, position 193.. Json data content:{"order":{"id":-,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/-","app_id":-,"browser_ip":"-","buyer_accepts_marketing":false,"cancel_reason":"staff","cancelled_at":"2024-02-01T15:49:32-05:00","cart_token":null,"checkout_id":-,"checkout_token":"-","client_details" ... 

We are setting up a business event to send an email to customers.  Can someone help us understand what the “Link to Account” does?  See below.  Does it record that we sent this email in the CRM Activities? Or something else? How are Link to Account and Link to Entity differ? We are on Acumatica 202 R2.   

Have you cleared your Sync history by mistake or on purpose, but found out you really needed some of it?   Or maybe you imported way too much history and want to start over, but many Customer have already been synced.  If you clear it, Acumatica will create a duplicate Customer later on.  If changes try to sync with an existing Sales Order for example it will give the error that the Customer ID cannot be changed. It is trying to use the new Customer it just synced.  To rebuild the sync history using the correct Customer:C