Retail Edition QnA
Updated 10/27/23 The following information answers many of the common questions about Acumatica’s Amazon Connector and our Managed Availability Program.At the bottom we provide a link to sign up for managed availability. This does not commit you to anything. Only let’s us know you’re interested and we’ll grant you access to additional information.General InformationThe Acumatica Amazon Connector works with 23R1 and beyond The solution primarily focuses on back-office efficiencies and accounting Pushing inventory levels to Amazon Pulling in Amazon (FBA and FBM) orders Push shipping notifications/tracking info to Amazon (FBM) Pull in Amazon Payments and Fees Statement reconciliation via Bank Feeds Personal Identifiable Information Protection (PII) More info below It supports FBA and MFN/FBM merchants Merchants use it to sell on Amazon.com and Business.Amazon.com Current merchants are selling in the US, Canada and Mexico New regions can be enabled Requires engagement with the cust
Dummy AttributeDescription: The Matrix Inventory feature in 2020R1 and 2020R2 requires the Template Item to have 2 attributes (ie color, size) to create Matrix Items. In some cases eCommerce merchants only require 1 attribute (ie size). This customization package will allow you to create a Dummy Attribute to fill the second, unneeded, Attribute but not display that Dummy Attribute on the eCommerce site.Works with: 20R1, 20R2Packages:Both packages are available on Github as Open Source solutions. To download the .zip from Github, click “Code” > “Download as ZIP”.Dummy Attribute - 2020R1 - Link Dummy Attribute - 2020R2 - LinkMisc: This functionality was added to 21R1 Matrix Item Import Scenario & Convert Stock Items to Matrix ItemsDescription: This package support 2 different features which are related.Feature 1 - The Matrix Inventory feature in 2020R1 and 2020R2 does not supported an “out of the box” Import Scenario. The following package includes everything required to import Pr
In continuation with the below article, the current article explains how the same can be done in 23R1 and the difference between 22R2 and 23R1. Like in 22R2, in 23R1 there are out of box import scenarios for Template Item(Import Template Items), Matrix Item (Import Matrix Items). The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed. The Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check All the above is done out of the box. Now to make the Template ID field editable in the Matrix item screen, the user has to publish the attached customization(“ImportMatrixItems2023R100.zip”) to this article. This customization package must be used only with 2023R1 and above. There is a customization package for users who do not have commerce module as well. Check the attachment: “ERPImportMatrixItems2023R1002.zip” For 22R2, check If the selected Templ
-----------------------------------------------------------------------------------------------------------------UPDATE: Now the Matrix Item can be made as Product Kit easily by selecting the Is a Kit checkbox in the Matrix Item form. Please check this article ----------------------------------------------------------------------------------------------------------------Create Product Kits as Matrix Items by following the below steps. Please pay attention to the screenshots were I have created a Template Item called EnergyDrink with the 3 Product Kits as Pack of 4, 8, 12 and linked them as a Matrix Items to the EnergyDrink Template Item. Steps:Create an Attribute from Attributes(CS205000) form, which would be treated as a Variant option to the Matrix Items. Create an Item Class from Item Classes(IN201000) form and link the Attribute created in step 1 and make sure the category is set as Variant. Create individual Stock Items from Stock Items(IN202500) form which are going
when I preparing the sales order it showing the following errorInserting 'CA Transaction' record raised at least one error. Please review the errors. FinPeriodID: 'Post Period' cannot be empty.
In the Shopify Stores(BC201010) and BigCommerce Stores(BC201000) form, the user can choose the option to show the discounts in Acumatica Sales Order as a Line Discount or Document Discount when orders are imported from External System. It cannot be both. When Show Discount In: Document Discount The order Level and item level discount from external system will be shown in the Discount Details tab in the document level in Acumatica Sales Order. This is the order created in BigCommerce. This is the Sales Order in Acumatica Also, When the Document Discount is selected the Discount Amount revenue will be recorded against the Discount Accounts as shown below. When Show Discount In: Line Discount The order Level and item level discount from external system will be shown in the line item in Acumatica Sales Order. When Line Discount is selected, by default, the discount amounts are not recorded against the discount amount But if Post Line Discount Separately is selected in the Order Type
In continuation withThe existing ImportMatrixItems customization is upgraded to 2022R2 with the below interesting changes. Now there are Import Scenarios for both Template Items and Matrix Items.Import Scenario for Template Items Import Scenario for Matrix Items The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed. The Template ID selector is always enabled and filtered based on the Item Class of the Stock/Non-stock. Template ID selector is filtered based on Item ClassThe Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check Template ID and Is a Kit fields are always enabledIf the selected Template ID in the Matrix Item does not match with default fields with each other then a popup warning is provided to the user. The fields that are checked are TypeValuation MethodTax CategoryBase UnitSales UnitPurchase UnitPopup warning when default fields
Hi All,As of this week Shopify has deprecated private apps that we used by Acumatica Shopify Connector.Here is the link to the announcement - https://community.shopify.com/c/shopify-apis-and-sdks/private-app-depreciation-and-using-custom-apps-instead/td-p/1465831 Acumatica Shopify connector in version 2020r2 and 2021r1 still uses private appsAcumatica Shopify connector in version 2021r2 and 2022r1 support hybrid mode: private, public, and custom apps are supported.Acumatica Shopify connector in version 2022r2+ supports only the public and custom apps. Privates app are deprecated and you have to follow the release notes to fully move from private app to custom or public. What does it mean to us: For users of 2020r2 and 2021r1 versionsExisting customers who uses an existing private will not be affected. Old private app will be still supported. New customers who want to use the Acumatica Shopify connector with NEW credentials (create a new private app), will not be able to do so. Since ne
In 2023R1, a new checkbox called “Disable Automatic Tax Calculation” is introduced in the Order Types(SO201000) form. When this checkbox is selected, the system will refrain from recalculating the taxes for the Sales Orders and Invoices. The Commerce connector will import the Taxes from external systems such as BigCommerce, Shopify, Amazon etc., if the “Tax Synchronization” checkbox is selected in the Stores form. If the “Tax Synchronization” checkbox is selected in the Stores form and if the selected Order Type in Order Type for Import selector has “Disable Automatic Tax Calculation” unchecked then a warning is shown to the user as “ The Disable Automatic Tax Calculation check box is cleared for the EO order type on the Order Types (SO201000) form. Taxes in sales orders imported from the BigCommerce store will be recalculated on invoice creation.” Once these taxes are imported, then it stays as the same even if the Sales Order or Invoice is modified. This “Disable Automatic Tax Ca
The Custom Field in BigCommerce could be added using the Commerce Connector from the Entities form(BC202000). Imagine you would like to map a attribute or custom field or any field from Acumatica Stock Item form to a custom filed in BigCommerce product page and this custom field in BigCommerce is not yet created. Go to Entities form(BC202000), select Stock Item Entity. Go to Export Mapping Tab Click plus (+) button In the Source Object, select the required Acumatica object. Eg: Attributes or Advanced In the Source Field/Value, select the required Field. In the Target Object, select the object as Product->Custom Fields. In the Target Value/Field, select <<Automapping>> as shown in the screenshot. Now when the stock item is exported next time, connector will automatically create the Custom Field in BigCommerce with the same name as in Acumatica. If the field already existing in BigCommerce then just the value of the field will be exported to existing field. Limitatio
Our customers get uploaded automatically from our CMS. By error sometimes twice. Once in acumatica, how do I merge the customers, so I have only one customer in acumatica?
This article will be focused on the specifics synchronization used in the Acumatica Commerce Edition for Shopify and BigCommerce connectors.First, lets define the synchronization process - Synchronization of any entity in Acumatica Commerce edition happens in 2 steps: Preparation and Processing.Preparation is a process when Acumatica gets information that any entity requires a synchronization (ex, new order has been created or product has been updated). When information is received, connector needs to create a record in the Sync History screen, logging that the record has been received and pending sync. Processing is a process when Acumatica loads one single record and synchronizes it from one system to the other. As part of the processing, connector will perform some addition steps: getting record from both systems, fields mapping from source to the destination system, user defined mapping processing, error validations, duplicate validations, saving the record to the destination syste
I want to show you a way how can you configure saving of a Credit Card Profile inside Acumatica even if the payment is done on the BigCommerce side.This functionality is possible only if both of the systems have integration with the same Credit Card Processing Center. In my case I will use example of Authorize.NET as this processing center is supported and by Acumatica and by BigCommerce. Step 1: We should configure Authorize.NET plugin at BigCommerce (under Store Setup → Payments) to store credit cards:Please note that it will be up to user to store or not the credit card information with you. Step 2: Now if user places the order, there will be an option to save card for the future usage on the payment settings:Please note that this option will appear, only if you have logged in user. For the guest user this option is not available Step 3: Now we should configure Acumatica to support Credit Card profiles. First place will be at the processing center level:And the second place under t
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 Made-To-Order product in BigCommerce directly. There we want to create Product Modifier Options with allowed values and combinations. For my spoon, I want to allow 2 fields: Message Font and Message
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 you can build out more robust
As a long time user of BigCommerce and a relatively new adopter of Acumatica, curious if anyone has developed a best practice for handling changes to product variants and getting those changes to sync properly between Acumatica and BigCommerce. Example: Product A initially set up with option for colors Green, Blue, and Red. Manufacturer drops Red and replaces with Yellow. Thus far I have tried a) removing the depreciated SKU as a matrix item from the template item and adding the new matrix SKU to the template and syncing - error, b) same process but deleting the depreciated SKU from BigCommerce first - error, and c) same process but deleting all SKU variants from BigCommerce first - error. To resolve a time sensitive issue, I essentially deleted the item from BigCommerce and started over by pushing the template w/ associated matrix items back to the store and updating key fields from a prior export, which is not a viable maintenance strategy. Any BC store owners have a good workflow
BigCommerce Integration VideosThis short video shares the most basic example of the integration between BigCommerce and Acumatica.Thorough introduction to the Commerce Edition for our VARs – 20 minutesThis is a thorough introduction of the 2020r1 Commerce Edition specifically for our VARs. I show a demonstration managing product data, Products with Variants, customer specific pricing, placing orders and processing shipments. Additionally I go into more detail about the connector, how it works, how data flow is managed and answer a few questions about pricing, etc. Quick demonstration of the Commerce Edition – 10 minutesThis is a brief demonstration of the Commerce Edition showing the product information flowing from the ERP to BigCommerce, the customer viewing and purchasing a product, the checkout process, the sales order creation from BigCommerce and the shipping status information flowing back to BigCommerce. Technical Deep Dive – 18 minutes Technical Deep Dive into the Connection
In our system, the item class creates attributes, how can I populate the attributes fields through an import scenario?
In 21R2 the Retail-Commerce team has added support for selling personalized items on BigCommerce and Shopify then passing the personalization instructions into the Sales Order. This feature was requested by several existing customers and prospects. It was possible to accomplish in the past versions with customizations, but now it is much easier.Here is how it works:On the eCommerce site you must configure the Made to Order item. Within the ERP you must add a field within the Sales Order to accept this information. This requires a customization package. Below we are sharing a template to help you get started. You must use the entities window to map the eCommerce field to the Sales Order field you must use the entities window to map the fieldsMore details about each step are below. Customization Package TemplateAttached here is a template customization package. The template, when installed in 21R2, will add a column to the line items within the Sales Order window. The column header is "
In this article I will show you how to configure Acumatica to automatically accrue Gift Certificate amount. Step 1: We need to create a new GL Account that will hold sold Gift Certificates value. Step 2: We need to create a corresponding Cash Account that will be used for the payment by gift Certificates. Step 3: We need to create a Payment Method that will accept payments by Gift Certificates Step 4: Now we need to create a Non-Stock Item that will represent a Gift Certificate item in the Sales Order. Please note that we should use Customer Gift Certificate GL Account as Sales Account in the Non-Stock Item settings. Step 5: We need to configure BigCommerce or Shopify to handle Gift Certificates payments and associate a Gift Certificate Non-Stock Item: Step 6: Place an order with Gift Certificate at BigCommerce/Shopify. In this example I’ll buy 100$ certificate:And proceed with checkout. Step 7: You will receive a Gift Certificate at your email address. Step 8: Synchronize the Sales Or
We have a client with multiple locations/warehouses. They use Big Commerce as a B2B site where the customer needs to be setup first. They are running into a couple issues I could use some guidance.Is there a way to display inventory availability by warehouse instead of just one specific warehouse or all warehouses? When a customer places an order the customer needs to have the all the items on the sales order assigned to the customer default warehouse, but it appears the integration changes the sales order line warehouse depending on availability. Is there anyway to force the sale order line warehouse to be assigned to the customer warehouse only?Currently the client is on 20R1, but we are looking to upgrade them to 20R2.Thanks,Kurt
Shopify updates it’s API frequently. They give their users 1 year notice when breaking API changes are coming which will impact any integrated apps with Shopify. This means that Shopify users must ensure their integrated apps (including Acumatica) are updated to utilize these new API changes.Acumatica requires customers to upgrade every 18 months as we support 3 major versions of Acumatica, concurrently. However, it’s important that customers using the Shopify connector upgrade once per year to stay current with the Shopify API. This will ensure they avoid connectivity interruption.Below is a compatibility chart showing the Shopify API changes and the version(s) of Acumatica which support these changes. Following this chart will ensure the sustainability and reliability of the Shopify connector.To ensure we keep our ecosystem healthy, Acumatica updates the Shopify connector with latest stable Shopify API version, semiannually. The continued support of the changes in the Shopify API ver
Just need to clarify - does the ecommerce connector support syncing a stock item attribute to a product variant metafield in Shopify? Or does it only support syncing to a product metafield?
We have customers and prospects with a requirement to assemble products based on a customers request, either through a ecommerce store or through direct input into Acumatica. Some examples of these scenarios are below: Variety Packs Pick any 6 of our flavors or frangrences to make your own pack. Using matrix items is not a viable solution given that these customers may have 300+ individual items. Made to Orders based on variables. Manufacturing is overkill and does not interface with ecommerce connector. Needs to be rules driven to avoid misconfigured items. Is this an indoor or outdoor applications? Do you want still images or video? What megapixel level? (doesn ot allow megapixel levels not compatible with video if selected) What country? Which cellular provider? (does not allow a provider which is not available in selected country) Issues: How to faciliate the order in the ecommerce store so that it passed to Acumatica correctly? How to faciliate the order for
For some reason the pricing sync for Big Commerce when you have multiple units of measure enabled is to use the base unit and not the sales unit. This is a major problem because customers build pricing based on the sales unit and not the base/stocking unit. How do we go about getting this changed? This is a critical issue for one of our clients. https://help-2021r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=994bc074-79eb-403b-81c4-9545d470a01dLimitations of Sales Price SynchronizationUOM-specific prices: In Acumatica ERP, if the Multiple Units of Measure feature is enabled on the Enable/Disable Features (CS100000) form, you can define a sales price of an item for each of the units of measure in which your company sells this item. However, only prices defined for the base UOM can be exported to BigCommerce.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
