Retail-Commerce

Commerce Edition QnA

  • 367 Topics
  • 1,525 Replies

367 Topics

josh.fischer
Acumatica Moderator
josh.fischerAcumatica Product Manager
published in Retail-Commerce

Amazon Integration - Information and Managed Availability Sign-upF.A.Q.

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

178928
josh.fischer
Acumatica Moderator
1 month ago
KarthikGajendran
Acumatica Moderator
KarthikGajendranAcumatica Moderator
posted in Retail-Commerce

How can I make a Product Kit as a Matrix Item?

   -----------------------------------------------------------------------------------------------------------------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

28
K
Freshman I
2 months ago
smarenich
Acumatica Moderator
smarenichAcumatica Commerce Edition Team Lead
posted in Retail-Commerce

How-To Manage Sales Categories only in BigCommerce with Acumatica Commerce Edition

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

23
L
Freshman I
1 year ago
K
Jr Varsity III
KurtBauerJr Varsity III
asked in Retail-Commerce

Big Commerce sales price sync with wrong unit of measure (UOM)

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.

21
Yuri Karpenko
Captain I
1 year ago
jgress
Jr Varsity II
jgressJr Varsity II
posted in Retail-Commerce

eCommerce Bundled Items or Assembled to Order

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

20
josh.fischer
Acumatica Moderator
2 years ago
M
Semi-Pro I
mikehoSemi-Pro I
asked in Retail-Commerce

Can the ecommerce connector sync a stock item attribute to product variant metafield in Shopify?

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? 

19
KarthikGajendran
Acumatica Moderator
10 days ago
Yuri Karpenko
Captain I
Yuri KarpenkoCaptain I
asked in Retail-Commerce

Acumatica App in Shopify Doesn't Work

On a number of our clients’ Shopify stores, we can’t access Acumatica App, getting this error: This happens in Google Chrome, Mozilla Firefox, and Safari.  Tried on Windows and MacOS.Any thoughts, @KarthikGajendran , @smarenich ?Thank you!

18
Yuri Karpenko
Captain I
1 month ago
M
Semi-Pro I
mikehoSemi-Pro I
asked in Retail-Commerce

Sync new products to Shopify in Draft status

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?)

18
M
Semi-Pro I
10 days ago
Yuri Karpenko
Captain I
Yuri KarpenkoCaptain I
asked in Retail-Commerce

Shipments with Multiple Packages - Export to BigCommerce

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!

17
R
Freshman I
11 months ago
D
Jr Varsity III
dgodsill97Jr Varsity III
asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

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.   

16
Chris Hackett
Community Manager
1 year ago
K
Jr Varsity III
KurtBauerJr Varsity III
posted in Retail-Commerce

What is the best way to handle a multi-warehouse setup with Big Commerce

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

15
M
Jr Varsity II
1 year ago
josh.fischer
Acumatica Moderator
josh.fischerAcumatica Product Manager
published in Retail-Commerce

Popular Retail-Commerce Customization Packages

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

162414
F
Freshman I
5 months ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

2020 R1-BigCommerce: How to fetch specific orders only, based on specific BigC order status

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 !

14
smarenich
Acumatica Moderator
10 months ago
KarthikGajendran
Acumatica Moderator
KarthikGajendranAcumatica Moderator
posted in Retail-Commerce

[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

14
priekenberg40
Jr Varsity II
5 days ago
Phil
Jr Varsity III
PhilJr Varsity III
posted in Retail-Commerce

BigCommerce - Product Availability & Inventory Settings Function Gap to Allow Preorders?

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

14
Phil
Jr Varsity III
26 days ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

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 !

13
smarenich
Acumatica Moderator
2 years ago
M
Semi-Pro I
mikehoSemi-Pro I
asked in Retail-Commerce

How to fulfill Shopify orders through drop ship PO in Acumatica

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?

13
Yuri Karpenko
Captain I
3 months ago
A
Jr Varsity II
AidenMissionJr Varsity II
asked in Retail-Commerce

Add Export Mapping To Shopify Entity

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!

13
K
Freshman I
12 days ago
J
Freshman I
JoeYTGFreshman I
asked in Retail-Commerce

Shopify Manual Tax Mapping

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

13
V
Freshman II
8 months ago
Yuri Karpenko
Captain I
Yuri KarpenkoCaptain I
asked in Retail-Commerce

Customer Price Class prices for Matrix Inventory - Sync with BigCommerce

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!

11
Yuri Karpenko
Captain I
7 months ago
M
Semi-Pro I
mikehoSemi-Pro I
asked in Retail-Commerce

ProGlove Mark 3 scanner compatibility

Does anyone know if the ProGlove Mark 3 scanner is compatible with the Acumatica mobile app? https://proglove.com/products/hardware/mark-3/

11
Dee Oujiri
Freshman I
1 month ago
M
Semi-Pro I
mikehoSemi-Pro I
asked in Retail-Commerce

Sync sales categories to Shopify metafield

Currently on 21R1, in the process of upgrading to 22R2 - is it possible in 22R2 to map product Sales Categories to a product/variant metafield in Shopify?

11
M
Semi-Pro I
9 months ago
B
Jr Varsity III
bernadeth58Jr Varsity III
asked in Retail-Commerce

Bigcommerce Orders are not in Acumatica Sales Order

Hi all. We have a lot of stuck orders in the Bigcommerce that are not in Acumatica. Any advice on how I can know the root cause of this?  Thank you.

11
F
Freshman I
11 months ago
H
Captain II
HarshitaCaptain II
asked in Retail-Commerce

An error occurred during processing of the field Applied To Order value 25 Incorrect value. The value to be entered must be less than or equal to 11.4500.

The following error is getting shown up whenever I am trying to import the Sales Order which consists partial payment with Gift Certificate ($25) through BigCommerce.  

11
C
Freshman I
1 month ago
josh.fischer
Acumatica Moderator
josh.fischerAcumatica Product Manager
published in Retail-Commerce

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 "

57010
Yuri Karpenko
Captain I
2 months ago

Badge winners

  • Easy talker
    KELhas earned the badge Easy talker
  • Financials expert
    marina25has earned the badge Financials expert
  • Easy talker
    aiwanhas earned the badge Easy talker
  • Easy talker
    tveldhas earned the badge Easy talker
  • Product guru
    sweta68has earned the badge Product guru
Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved