Retail

We are new to the platform.  We are experiencing difficulties when trying to sync returns from Shopify.  We are getting the error message: The following tax identifiers from the external system could not be matched: PA STATE TAX. The ERP has failed to save the tax ID or the tax amount differs from the one that has been expected. Make sure that taxes are configured for the tax zone and tax categories. Also, make sure that taxes either have the same identifiers in the ERP and external system or are mapped on the Substitution Lists (SM206026) form. Has anyone experienced this issue and how do we correct the issue?  We are currently manually entering all returns into Acumatica at this point. We do not experience this problem with a normal order or with a POS return.

While working through an RC, is there a way to process it like the “Pick pack and ship” or “Receive and put away?” We have several coming back as a stock lift so one RC could have 10,000 pcs.  I’m sure something is available, but I cannot seem to find it through my VAR, or my limited research.

Price list syncs are taking a very long time, over 20 hours. Not to mention it usually errors out and needs to be manually restarted in this time period.I have tested this with a lot of price changes, and minimal price changes, and the time to sync did not change.Is there a better way to automate this process, and to only update the items which prices have changed (either + or - amount)?BigCommerce did recommend using Price List Importer/Exporter | BigCommerce. I have tested this on Sandbox, and this is a very fast way to update multiple price lists for multiple items at once (I did about 6,000 items in < 10 seconds). While this is an adequate solution, I don't see any way to automate this.

Using the BigCommerce/Bundle B2B connector, is there any way to handle the following business need? We would like to create a specific Sales Price Worksheet for approximately 600 of our customers. In Acumatica, this is feasible in the Sales Price Worksheet module by attributing the worksheet to a specific Customer Price Class and then assigning that Customer Price Class to the 600 customers. There doesn’t seem to be a way for BigCommerce and Bundle B2B to read that information in the hierarchy we are looking for. Any suggestions?

I have an export scenario set up to export using the Customer screen layout to an excel file.  I am trying to export the following records from the Customer screen and want to use a Source restriction to restrict the export to a couple particular customer classes.When I run it using the source filter (and not setting the customer id to ‘=every’, the address field data for the account and shipping addresses that are exported are all the same as the first customer, although other fields do export correctly.Any thoughts on what I can do to make this right so I can use source restrictions? My testing of using the =’every’ for customer ID and a source restriction results in no data being prepared all all.  The example below has the =every, but removing it is what gives me the same data in the address fields for all records.Any thoughts are greatly appreciated! 

Register Today: 

 Our client has received the following email from Shopify.. The customer is preparing to upgrade to 22R2 build 202 right now. Any impacts of these that we need to be aware of or execute.   Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023Your custom app is leveraging the deprecated Fulfillment API. Please note that the Fulfillment API will stop working as intended on March 31st, 2023 in favor of our new Fulfillment Order API. Read our 

Is it possible to import historical orders via the Shopify connector?In my testing, archived orders are filtered (excluded) from the import by default.Customer would like to import historical orders for reporting and customer service reasons.Thx / Chad 

We would like to map the Acumatica Entity Usage Type field in a Customer Profile to the analogous field in BigCommerce’s Customer table, so that we can set whether a customer is tax-exempt or taxable from Acumatica. We use Taxjar as our tax solution, and to set a customer as taxable such that the Tax integration between BigCommerce and Taxjar will work properly to recognize the tax status of a customer, we need to either leave the field blank or fill it with “TAXABLE”. Any value other than Taxable in the BigCommerce field will send a customer tax-exempt value when Bigcommerce does an API call to Taxjar for that customer.If we sync the field as it stands now, the value for taxable in Acumatica in the Entity Usage Type is “Default”, which if entered in the BigCommerce field will make that customer exempt (opposite of what we want). Is there a way to either update the pick-list for entity usage types in Aculatica to add “TAXABLE”, or for us to use some sort of substitution in th

Hello, We have been having an issue with our BigCommerce connection into Acumatica whenever a customer creates their first order on the website. When the customer creates an order from BigCommerce, it syncs into Acumatica and uses the Ship To Name and Address for the Customer profile instead of using the Bill To Name and Address. We have to manually override the Name and Address every time, on every tab to correct this. Also, if a new location is created in Acumatica for that customer, it defaults back to the original Attention and Ship To Addresses that were incorrect, even after they’ve been changed.  Any ideas for a fix to this issue? Thanks!

We use Apruvd on our Shopify store to protect against fraud on credit card orders. Does anyone know of a solution (Apruvd or something similar) that integrates well with Acumatica?

Hi All, one of our customers is wanting to integrate with Amazon in the UK, the native connector is not currently certified for Amazon UK but the customer has Shopify. I was wondering if anyone had any experience with one of the apps at all? I take it shopify gets the amazon order, syncs to acumatica, acumatica processes the order and it does the reverse back to shopify and amazon but any info from people with experience would be appreciated. ThanksMatt

We just want to confirm if this is what we expect for the connector when a customer was deleted in Acumatica. Please consider the ff:1. A customer was created in Acumatica2. It was synced to BigCommerce3. Customer now exists in BC4. Customer was deleted in Acu5. Synced the customer in AC sync history6. Customer still exists in BCIs it what we are expecting? Do we have some indication in BC if a Customer was deleted from it's Acu source? Can we forbid them to log-in and place order in BC? Thank you 

Acumatica 2020 R1, Build 20.101.0032, Screen ID: SO301000 Is there any way to overwrite the customer tax zone field based on order type? We have an external selling channel that collects sales tax on our behalf. We create these orders in Acumatica for fulfillment and inventory allocation purposes, but we don’t need sales tax to be reflected since it’s collected by the third party.  Open to any suggestions that could eliminate the need for manually overwriting and changing the tax zone - as that could be an easily missed step.

How can I configure the Shopify connector or Acumatica to use the sales unit or Qty. on Hand instead of the base unit for product availability?   This should be 6   Thanks!

Hello everyone!Do you have any success stories with Acumatica & a bookshop? It would be helpful if you could provide me with a reference in this particular retail store. Thank you so much for your help! My chances of winning a deal could improve if I use it! -David 😎

Hello, my company switched to Acumatica this year. For our b2b website we went down the road of  using BigCommerce and the Acumatica connector for it but I’m not much of a fan of the BigCommerce environment so am looking at alternatives.  Our current website is PHP/MySQL based (which is what I know best) but is still using our old ERPs “cart” integration, which is no good long term (we basically have to continue to maintain and setup products in our old ERP just for this cart purpose and then export them out and import them into Acumatica).   I’m curious if others are using any custom or off-the-shelf site/cart solutions which are integrated into Acumatica via the API, besides BigCommerce/Shopify/Magento.  Our current website’s data is already being pulled from Acumatica (the MySQL db is updated with Acumatica data daily), I just essentially need the “cart” part and then the ability to automatically push those submitted orders into Acumatica. Any comments/thoughts/advi

Hi Team,We have some business scenarios where we are syncing the orders from BigCommerce, processing that in Acumatica, and Order gets completed and the order status in Acumatica is marked as ‘Completed’.Now on BigCommerce, the order gets modified and we have to resync the order to get those updates reflected in Acumatica, but during this scenario the connector is not picking up this particular order as this is already marked as completed withing Acumatica.Can you please suggest the best possible way to achieve this, to re-sync the orders even though those marked completed in Acumatica, through manual or Real Time or through a scheduler sync. The particular build where we are trying to achieve this is 21.119.0030. Thank you in Advance! 

Hi everyone, I just have a question.Do B2B Bigcommerce supports Sales Prices sheet,  customer specific discount, qty discounts on a line item level, and order level discounts from Acumatica? I just want to make sure that everything how it is currently operating in Acumatica, can be replicated in BC. or whether TranZetta pricing will work. Thank you. 

Hi,  I’m wondering how to manage the stock and sales for used inventory.Say we sell item A as a brand-new product, but we’ll sometimes get a return where the product isn’t in brand new condition. We now want to sell Item A as a used product for a discounted price. We need to have a way to manage the inventory, sales, and cost of this product. It shares the same product ID and barcode as the brand-new product. Creating a new product ID and adjusting the inventory will create an issue since it won’t show the cost of the product.

Hello Everyone,For Acumatica 2020 R1 version, is there any possibility to fetch specific orders, based on specific BigCommerce order statuses from BigCommerce to Acumatica.For an example: I want to fetch only the BigCommerce orders having order status as: “Awaiting Payment” and to import further in Acumatica.Can we achieve this from any mappings/configurations or we have to do a specific customization. If customization is needed, can you please help with sample code. Thank you in advance !

When sales orders are pushed into Acumatica and are in a status of Open but the Sales Order has not been approved in Acumatica, the BigCommerce Connector pushes back a status update to the order in BigCommerce and changes the order status to “Manual Verification Required”.  Is there a way we can change that mapping and/or ignore that in the connector?

Does anyone know how to have the sales price from the “Sales Prices” show up as a column on the Inventory Items query?I have been able to do it, but it duplicates the inventory items many times. Here is how I built the relationships: What am I missing? 

We have a client that needs to implement Stripe so payments from events can be uploaded automatically into Acumatica under a general Customer ID. Then these transactions would be offset against a project under the Projects number and Project Task. Do we need to get a connector through an ISV for this? I know Acumatica has a license feature for Stripe. Any insight would be helpful or instructions? 

Hello! I’m having an issue with the sync between my BigCommerce store and my Acumatica Sandbox environment. I have a customer that will not sync to Bigcommerce. Previously it had been syncing to our Bigcommerce stores, but I believe that at one point the account on the Bigcommerce side had been deleted. Now, when I go to process data (or sync from sync history), the sync runs indefinitely. It does not throw an error, it just keeps going with no result. I’ve tried re-creating the customer in BigCommerce and changing the external ID on the sync to match the new one. That did not clear up the issue. Any ideas?