Hi all! We are currently on 2023R1 and plan to upgrade to 2023R2 very soon.
We have a group of products - safety glasses - that have pricing set by the pair of glasses, but we sell them in box quantity of 12. In the individual stock items and the template items when applicable, the conversion is set with EA as the base unit, BOX as the sales and purchase unit. The EA to BOX conversion is defined. When we export these glasses to the website, the price and product availability are showing up as the Base Unit instead of the Sales Unit, which is not what we want. We would like the export to shopify to use the Sales Unit.
I’m providing a few screenshots here to illustrate the relevant details:
Stock Item Page - Base/Sales/Purchase Units are defined hereLinked Template Item page - Base/Sales/Purchase Units are defined exactly the same way hereStock Item Price (price differs by lens color so price is defined here, for base UOM)Vendor purchase unit is set to BOXVendor purchase unit is set to BOXWhen this item is entered into a sales order, the price defaults to BOX and the price multiplies out from the base price.This is how the product exports to the website with the default settings.
Does someone here know if this issue will be resolved when we upgrade to 2023R2? Or do we need to customize the export mapping to account for this?
Thank you!
Julia
Best answer by Yuri Karpenko
@jfarrell , I have just tested this. These are my steps:
Created a new SKU with EA as Base UOM, and BOX as Sales UOM (BOX = 4 EA)
Synced the product to Shopify. The price in Shopify = Default price in Stock Item screen in Acumatica.
Received 10 of these EA’s into Acumatica. Prepared and synced Product Availability entity. The quantity in Shopify is 2, which seems correct to me.
The only issue is the price. The default price in Acumatica is for the Base UOM.
I’ve heard the opposite requests re: UOM, i.e., some companies have a BOX as a Sales UOM, but want to maintain prices and quantities online in EACH. From my experience, and according to the documentation, Sales UOM is what is used for inventory export for both, Stock Items, and Template Items:
I’ve heard the opposite requests re: UOM, i.e., some companies have a BOX as a Sales UOM, but want to maintain prices and quantities online in EACH. From my experience, and according to the documentation, Sales UOM is what is used for inventory export for both, Stock Items, and Template Items:
Hello @jfarrell , @Yuri Karpenko , this issue is already fixed in 2023R113, 2023R204 and later build.
Description:
During the export of a stock, non-stock, or template item to a Shopify store, the item's default price and MSRP were imported in its base UOM instead of its sales UOM. Fix Description: Now the default price and MSRP are exported as follows:
Default price: The system looks for an effective sales price defined for the item on the Sales Prices (AR202000) form that meets the following criteria:
Type: Base
UOM: The item's sales UOM
Warehouse: Empty
Currency: A currency supported by the Shopify store
Break Qty.: 0 or 1
If such a sales price exists, it is exported instead of the default price of the item. Otherwise, the item's default price specified on the Price/Cost tab of the Stock Items (IN202500), Non-Stock Items (IN202000), or Template Items (IN203000) form is recalculated for the item's sales UOM according to the UOM conversion rules specified for the item on the General tab.
MSRP: The MSRP specified on the Price/Cost tab is recalculated for the sales UOM according to the UOM conversion rules specified for the item on the General tab.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
