Commerce Edition QnA
- 367 Topics
- 1,525 Replies
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
-----------------------------------------------------------------------------------------------------------------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
Hi All,In BigCommerce the sales categories are mandatory to create a new item, so that is why Acumatica-BigCommerce connector requires to have at least one category during the export. I would also recommend you to manage Sales Categories in Acumatica, this will simplify the process and allow you to have one source of truth. However, if you really need to manage sales categories in BigCommerce only, I can suggest you the following customization that will disable categories synchronization for existing items. Only new items will still require at least one sales category: Step 1: Go to Item Sales Categories screen (IN204060) and create 1 category with name “Unassigned”. Name can be anything, Unassigned was used just for example. Step 2: Go to BigCommerce Stores (BC201000) and used Unassigned category as the default Stock and Non Stock Item category. This will allow you to export a new item created in Acumatica to BigCommerce without any error. Step 3: Publish the attached customization “B
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.
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
When we create new products in Acumatica, we do not want them to show as Active in Shopify until we have a chance to update images, tags, etc. in Shopify. (We handle all of that in Shopify, not in Acumatica.)The connector automatically creates new products in Active status; is there a way to change this and set these products to Draft status when they are initially created? (Outside of creating a custom field or attribute and mapping to the Status field?)
Hello, a few of our client have the same issue: when exporting shipment information from Acumatica to BigCommerce, the export fails, when there are 2 or more packages on the shipment, and no items are assigned to each box:The error on the export would be: The [shipment number] shipment could not be exported because the [tracking number] box has no items. Please delete this box or assign an item to it.Can we have Acumatica disregard any and all tracking numbers, UNLESS it’s the only tracking number (1 package on a shipment) or the package has items assigned?Thank you!
There are only 2 choices to show available for the web store. My client would prefer that negative available is ignored and factored into the calculations. In the example below, they want to see 10.This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20 If I allocate the sales order for the 10 pieces it changes to either 8 or 10. Generally, we do not set the sales orders to allocate because it ties up inventory you could use for orders with earlier ship dates. Unfortunately, there is no way to allocate orders based on date.
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
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
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 !
[22R2]-Import Matrix Items, Template Items using Import Scenario, Convert Stock/Non-Stock item to Matrix Item and vice versa..
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
Context: Allowing preorders for BigCommerce products (stock items). We’re currently on 2020 R2 (updating to 2021 R2 in the next 90 days) and on the BC Enterprise storefront. BigCommerce Requirements: To properly allow the native ‘preorder’ functionality to work on BigCommerce, two settings need to be adjusted:‘Availability’ needs to change to ‘This product is coming soon but I want to take pre-orders’ ‘Inventory Tracking’ method needs to change to ‘Do not track inventory for this product’Acumatica Settings: At the individual stock item level, it is possible to adjust the ‘When QTY Unavailable’ setting within ‘Inventory Settings’ to ‘Set as Pre-Order’. Sounds great. Acumatica Behavior: This ‘Set as Pre-Order’ action only adjusts the BigCommerce ‘Availability’ setting to the required ‘This product is coming soon but I want to take pre-orders’. However, without the ‘Inventory Tracking’ setting getting updated in tandem, the action of allowing pre-order isn’t actually achieved. There are o
How to sync Sales Order User Defined Fields at the time of Order Import from BigCommerce to Acumatica
Hi Team,We have a requirement where we want so sync some BigCommerce order details to Acumatica Sales Order User Defined Fields at the time or order import.Can someone suggest the possible way to achieve this. Thank you in advance !
We have drop ship products on our Shopify site - if purchased, the order will sync to Acumatica, a drop ship PO will be created, and then a drop ship receipt once the vendor has confirmed the order has shipped.Is there a way natively to mark these orders as fulfilled in Shopify? This happens automatically for orders with product we stock and can ship from our own warehouse; a shipment is created and confirmed and the order is marked as fulfilled in Shopify. However, because the drop ship process uses a receipt instead of a shipment document, and there is no place to enter tracking # information in a receipt, we cannot see a way to mark the order as fulfilled in Shopify.We are currently on 21R1, in the process of upgrading to 23R1; perhaps this has changed in the latest release?
Hello,I am Trying to find where/how to add a new “ERP Field / Value” to the BC202000 screen. We would like to be able to push an attribute with the “ERP Object => Template Items → Matrix” like we are able to with the “Template Items → attributes”.Or we would like to be able to push a custom field on a matrix item so we can push our UPCs to Shopify. How can I add custom fields to this dropdown?I’ve been looking through the PX.Commerce.Shopify source, but as far as I can find it pulls the values out of the ether.Thanks in advance!
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
When syncing Customer Price Class (type) price lists that contain prices for matrix inventory and template items to BigCommerce, the price list in BigCommerce contains the list of items, but the prices are all $0.00.This is how it’s set up in Acumatica:and this is how it comes out in BigCommerce:I’m aware that Customer specific prices are not supported by the connector, but this is not a customer-specific price.Any ideas on how to overcome this issue?Thank you!
Commerce 21R2 - Selling Made-to-Order, personalized products in Shopify or BigCommerce is now supported
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 "
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.