Retail

Hi all,I know this is a very basic question, but sometimes confuses our users. In the Sync History, we have the column ERP ID, and it can be easily understood to refer to the Stock Item SKU. But the details displayed are Item Descriptions, and you are not able to search items using SKU/ERP ID. Any reason why it was called ERP ID, though it was intended for Description or Product Names? :)Thank you  

Hello:How Can I import an attribute multiselect?, I attached a file with the message error.Thank 

We have non-physical items that are sold on our Shopify store (software downloads). These are set up with the “This is a physical product” box unchecked in Shopify: However, this means that customers will not be prompted to enter a shipping address. Because of this, it seems we are getting a sync error: “Taxes cannot be calculated via the external tax provider because the address is missing”.We can go into the Shopify order and manually add the billing address as the shipping address and resync the order which works, but is there a way for us to still sync the order even without a shipping address?

The Order in External System might not have Ship To Address because all the items within the order are non stock items or digital items. Digital items do not require to be delivered physically and hence there is no ship to address. When such orders are imported into Acumatica, you might error related to Taxes or about missing the Ship to Address. Follow the below steps to successfully import the order. Make sure the non-stock item has the right Tax Category.  If you are using Automatic tax engine like Avalara for tax calculation, then make sure the non-stock item has the non taxable tax category. Eg: ON030000  The complete list of Avalara tax categories can be found in this link https://taxcode.avatax.avalara.com/ If it is manual tax setup, then make sure the taxes are configured to not calculate taxes for this non-stock item. 

Wondering if anybody has used the GiftShip app with Shopify and if so is there a way to map the gift message you can leave through to the sales order on Acumatica to print on documents?  Wasn’t sure if the Shopify Connector within Acumatica would recognise any of the new fields.

Starting from 2022R116 the users can import the Shopify Orders with the entities like Tips using the following scenario:Create in ERP non-stock item withe exactly the same product description as it appears in the Shopify order:   Then try import the order with tips. It will look like:    This logic should work for any entity which has no SKU and productID on the Shopify side  and which the user wants to import to the ERP.In this case the system will search the ERP Items by the product description.

To assure compatibility with the enhance security provided by TLS 1.2 (which is now mandated by Microsoft and other system vendors), all FusionPOS registers must be updated prior to January 1, 2023.Failure to upgrade may result in the register processing transactions as desired. Please reach out to support@fusionrms.com to schedule your upgrade.Regrettably, with the FusionPOS register upgrade, Authorize.net will no longer be supported for integrated credit card processing. For FusionPOS users who are now using Authorize.net we are happy to offer other alternatives for integrated credit card processing. https://fusionrms.com/credit-card-processing.

Hi everyone.We encountered this issue. In the Bigcommerce, If a Customer uses a Credit Card during the checkout process, we have to Override their "Default Payment" method on the sales order.  It needs to be overwritten with "AUTH NET." I just conducted a test transaction. The Customer in question has a default payment method of "ACH." But, during the checkout process I used a Credit Card. When the order synced to Acumatica, the Sales Order pulled the default payment method of "ACH." This issue gets even worse when a Customer has a Default Payment Method of "CREDITCARD" in our system. In that scenario a Customer could pay with a credit card during Checkout and then Acumatica will run their card again when the order is invoiced. Double charging the Customer.

Is it possible to allocate product to ship from a specific warehouse location based on the customer’s location? For example: ItemA is available in both California Warehouse and New York Warehouse Customer is located in Colorado and orders ItemA Acumatica automatically allocates inventory to ship from California Warehouse

We have a requirement from the client that during the customer sync from Acumatica to Shopify, Connector has to split the first and last name of the customers from the Account name with reference to the first space starting from left. For e,g. Let's say if a customer name is “Mike Thomas Gorden”  Connector while syncing the name to Shopify first and last name field, the connector should check for the first space from the left and split the name into two parts as first and last name and send it to Shopify.Based on the above example Connector should sync the first name: Mike and the last name: Thomas Gorden to Shopify. To fulfill the customer requirement we have defined the following mappings at the connector Customer entity levelValidation has been successfully passed but while syncing the customer from Acumatic

Is it possible to automatically add a non-stock item when a specific sales order type is selected/created? For example, we would like to be able to have a non-stock item automatically added to orders from a specific channel to make sure promotional materials specific to that channel are included in the shipment.

A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica.  Instead the just want to have each variant as a individual SKU in Shopify.  The Shopify help says to delete the variants and the default.  They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs

Hi,We are using the BigCommerce connector with acumatica 2021 R2, but have noticed that payments do not sync from BigCommerce if the order type in BigCommerce is “Manual Order”. These are orders that are taken manually by staff using the backend of BigCommerce. They use exactly the same payment method. In fact, I have compared the GET results of the “payment” endpoint for a normal website order, and a manual order, and the payment REST response looks identical from BigCommerce. So is the acumatica connector programmed to NOT sync these payments? If I try to manually sync the payment (Sync History->Add New->specify the external order ID) then it says “the payment record cannot be syncronized because it does not exist in the external system) Hoping someone has some insight, as I can’t find any information in the documentation as to why these payments can’t be found by acumatica. ThanksGeoff 

We need some help with the following issue:  We have items in Acumatica that we have sold the last one, and made inactive in Acumatica.  We have set up our Acumatica-Big Commerce Connector to make such inactive items not appear on our Big Commerce Website.  The items still show up on our Big Commerce website.  We are confused why the items are still showing up on our Big Commerce site.

Where can I see our Acumatica “usage”.  My understanding is our Acumatica license cost is based on usage.  So, I want to monitor our usage so I can compare  our usage to what our license allows or what we are paying for.  Thank you for any help you may give us. 

We would like to have a sales order type such that when selected to start a new sales order the ship-to address and ship-via for pickup will always be the same address/SHIPVIA and override the customer’s and/or customer class ship-to address/SHIPVIA.  Is this possible?

HelloAbout the different “Tax Type” available in the “Taxes” settings in Acumatica:I would like to know if all types need to be integrated/supported for the retail-ecommerce (ex: VAT, Sales, etc) or if only the type “Sales” can be used? If the tax type “VAT” is selected for a Tax ID, is there any impact on the retail-ecommerce for the related options that can be checked (ex: Reverse VAT, Internal VAT, etc)? Do we need to integrate all of them? Is there any document for retail-ecommerce about the different tax type integration with retail-ecommerce?Thank you, 

Hi All,During the implementation of different commerce connectors, you may face some issue or errors. In case you want to troubleshoot what is happening wrong, you may find Logs of the commerce integration very useful and beneficial.To do so, you should first enable logs in the Request Profiler:When logs are fully enabled, you can perform the sync you want to troubleshoot. Finally, you can go back to the request profiler and find out logs.In case you want to review requests and have many of them, I recommend you to apply filtering by user, screen id (BC3010000), or operation (sync).However, the most beneficial type of logs is - Event Log. This tab will provide

Hi Everyone, We are planning of creating custom field in our Bigcommerce and Acumatica as a Job tag for each sales order line of the Blanket sales order. Is it possible to use it in creating child orders based on that custom field? Thank you.

We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”.  Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced.  We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area).  Is this method the prefered way sync?  Should we stop using the “Sync” button in the “Commerce / Processes” area?  

The current Acumatica Shopify Connector doesn’t process the shipping information during Sales Order Import. But in some cases, Shopify Order will be fulfilled by other 3rd party service, and you want to import the shipping information into Acumatica Order if the order has been fulfilled. This request can be resolved by using customization project:namespace PX.Commerce.Shopify{ public class SPSalesOrderProcessor_Extension : PXGraphExtension<SPSalesOrderProcessor> { public delegate void SaveBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing, String operation); [PXOverride] public virtual void SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, String operation, SaveBucketImportDelegate baseMethod) { //Local is the API Object from Acumatica SalesOrder localOrder = bucket.Order.Local; //Extern is the API Object from Shopify

I have been asked to enable updates from Acumatica to BC when Sales Prices are updated using Sales Price Worksheets. We have several customer price classes in Acumatica (RET, WHL, 1STWHL, GUEST and Base). Any changes to prices for items made that day are updated every evening with a price class worksheet for each of these Price Classes.We want these updates to propagate to the sales price  in BC automatically.In BC we have Price Lists for:WHLRETGUEST (inactive currently)and Customer Groups for : 1STWHL, WHL, RET, GUEST Is this something that is built into the BigCommerce Connector?  I am a bit confused.  I opened the Entities screen and see a Price List option.Do I simply make this active and then do a manual sync? I also see in the Push Notifications that there is BC-PUSH-Prices.  If I open BC-PUSH-Prices and check the conditions it seems to be linked to AR-SalesPrice which is what I believe the Sal

Hi Everyone, I need a modifier (dropdown type) in some of the Items in the Bigcommerce that should came from Acumatica. I only know how to create a template item and building variants through attributes. But what I need is a modifier that will not create a new SKU/variant when I select the options.Is this possible?I made an example: the one under the category attribute should be the modifier But it didn’t sync in the BigCommerce 

The sync fails on a useless message.Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Hi All. Anyone here who can help me get the right price in the Bigcommerce B2B  from Sales Price in acumatica without syncing the customer price class in the entity setting? Thank you.