Retail

Hi Team,We are working with BigCommerce connector (build: 23.105). In BigCommerce Stores screen under inventory setting tab, we have Default Stock Categories field (Dropdown field) it loads all item sales categories by default. I want to override this field to load only required categories. We tried with fieldSelecting event but values are not updating in the Default Stock Categories field. Can you please review below details and suggest the best possible way to do that. Graph:   public class KNBCROBCBigCommerceStoreMaintExt : PXGraphExtension<BCBigCommerceStoreMaint>    {        public static bool IsActive() { return true; }        protected virtual void BCBindingExt_StockSalesCategoriesIDs_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)        {            BCBindingExt row = e.Row as BCBindingExt;            BCBinding bCBinding = PXSelect<BCBinding, Where<BCBinding.bindingID, Equal<Required<BCBinding.bindingID>>>>.Select(Base, row?.BindingID);

We’re just rolling out Acumatica. We’re starting to utilize Template Items heavily. I’m wondering if there’s a feature we can turn on to just auto-generate the Template ID rather than having to enter something? It would save a lot of time! 

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

We recently upgraded to 23R1 and are interested in turning on the Order Types for Export feature under Shopify Stores > Order Settings in Acumatica. However, we’re trying to get a better understanding of what will happen once we select the order types that we want to export to Shopify.Does anyone know if the connector will sync all historical orders of those types? Or will it sync only new orders from that point on? Is there a way to control which orders are synced?

My shopify sales order is imported with a ship via that is checked as will call. This Ship Via is called PICKUP and is also set to my store shipping method. Shipment export to Shopify generated the following error:Error converting value "pick-up" to type 'PX.Commerce.Shopify.API.REST.FulfillmentOrderDeliveryMethodType'. Path 'fulfillment_orders[0].delivery_method.method_type', line 1, position 1459. Am I missing a mapping? Thanks!  

Hi,  Acumatica automatically sends the Vendor Ref number on Purchase Receipts to Shopify as the tracking number. Since we’re using the field for what it was actually intended for (Invoice Numbers), can we restrict Acumatica not to send those?

Is there a way to change the Qty Selected in the Add Related Items box?  You can change the Quantity at the top of this box but not the quantity of the individual items listed below in the box.  In our case, we may need multiple of an additional item to Cross-Sell.  It isn’t always a 1-to-1.  As it is now, you need to change the quantity after it pulls the item(s) into the Sales Order.   Thanks

We just upgraded to 23R1. Prepare Data works for the Product Availability entity, however when we try to Process Data for this entity all of the records fail with the following error:  Error on location_id : Required parameter missing or invalid; Anyone else have any experience with this type of error? My understanding is the Location ID is not a required field under the INVENTORY SETTINGS > WAREHOUSE MAPPING FOR INVENTORY EXPORT of the Shopify Store in Acumatica; does this error imply differently?

It’s possible to create a Purchase Request with an Non Stock Item?We want our store managers to request purchase items, but maybe they want to request new items that are not created as Stock Item.

Hi. We are planning to connect two stores (B2B and B2C) Bigcommerce in one Acumatica. May I ask what are the risks if we push it? Thank you.-Bernadeth

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

Hello everyone,I create matrix items from a Template Item, with description segment settings uses the Template Item Description together with Attribute value.After creating matrix items, I updated the Template Item Description, hoping that it will auto updates every matrix item description inheriting the changes I made in the Template Item.   But it does not.Clicking the Update Matrix Items button doesn’t work also.Is there a way to update the matrix items description from the template description changes without updating each of them?Appreciate your help. :) 

Hi Acumatica Forum -  First - I’ll call out that I’m new here. If I am posting in the wrong place (or posting something obvious), please let me know.  Now, getting to business. I’m trying to use acumatica to do some pricing calculations and updates automatically. I’m finding it to be quite limiting. I’m curious how other retail locations use acumatica and how they update prices.  Specific things I’m trying to do: Rounding - I’m trying to implement basic rounding rules (i.e., all prices need to end in $X.99) Pricing Overrides - setting up prices that aren’t automatically repriced  Pricing Experiments - setting up a control and treatment group (at the item level) to see how much customers respond to select price decreases (by shifting purchasing).  Pricing alarms - for example, sending an email if we sell an item below cost. At this point, we’re doing pricing through downloaded spreadsheets. But there is no way that will be sustainable in the long-term.  Thanks!David   

How to make the Subaccount of each line items in Client invoice automatic, based on the Project ID not based on the Customer’s.When I am creating an invoice, then adding a line item in the details tab the sub account auto fills in from the customer’s GL account, so how do I make it autofill from the Project instead of the customer? 

Hello,We are trying to get the classification to transfer from Acumatica to Pacejet. We are able to get the dimensions, weight and declared value to transfer.Can someone help us with getting the NMFC code to transfer.Thanks 

Is anyone familiar with how Acumatica handles the following scenario?We sell services such as "maintenance," "warranties," or "bundled products," where it's not possible to recognize the entire revenue at the point of sale.For instance, let's consider a warranty that covers one year, priced at USD 1,200. The revenue from the sale should be distributed as USD 100 per month. what is the actual process in Acumatica system?

I’m not sure if this is the right place to ask this.  If not please accept my apologies in advance. We have several template items that are giving this error when trying to sync with BigCommerce. One example is below:Error: Option values ids on update should belong to the option, the following is were not found: 6593; Status: 422 How can I find out what the missing Option ID is referring to?More generally, is there a way to set up the Template items so that Acumatica will update BigCommerce automatically, without manual intervention, either overwriting what's there or creating an alternative listing?Thanks for any advice, Phil

Is it possible to leverage two different native connectors for WooCommerce and Shopify for two different tenants in a single Acumatica instance. 

I need to map the phone number associated with the default address from Shopify to a specific field in the customer record in Acumatica, but I can’t seem to figure out how to specify the phone number associated with the default address, not the phone number associated with one of the other (non-default) addresses, in a formula in the Customer entity.Does anyone have a suggestion regarding how to accomplish this? 

I have some items on Shopify assigned to non-Acumatica locations (drop-ship), I want that when the item does show up as available in a Acumatica warehouse it should sync to Shopify. It doesn’t sync with the real-time sync or the manual processing. Only when I sync the item through the sync history screen. What do I need to do to get it synced in real time?

Hello everyone! We are converting our inventory into a template-matrix item using this customization: https://community.acumatica.com/retail-commerce-113/popular-retail-commerce-customization-packages-6934I am just facing some concern when there are some corrections made in the stock/matrix items in Acumatica that should reflect in BigCommerce.Consider an example of a template with attribute Size (Small, Medium, Large) and Color (Red, Green, Blue). Not all permutations are available. And the item was synced in BigCommerceNow, the business decided to change the color attribute name from Red to Rose, Blue to Navy Blue and Green to Lime Green. It was changed in Acumatica, but the variant details was not reflected in BigCommerce.Maybe one way is to delete the item in BC and resync the item. But that is not desirable especially if we made lots of changes in BC side of product details, and a transaction has already been made. Can you pls help how to fix the issue? Thank you 

Background: In Canada, more than one province has the same tax code but with different tax rates. That is in Ontario the tax code used is HST with 13% and in New Brunswick it is HST with 15%. In Acumatica, a same tax ID cannot have two different rates. And in Shopify the Tax Code cannot be changed manually for US and Canada. But for other countries, the tax code could be manually modified. Commerce Connector:Connector should get the HST code from Shopify order Api for both provinces and import the order with appropriate tax rates in Acumatica. How is it done?Commerce connector works the following way for the Tax ID comparison for Order imports. Checks the Shipping Address first. If not found, then Billing address and gets the Country Code and Province Code from the address and does the concatenation as TaxCode+CountryCode+ProvinceCode for Tax ID.Eg: HSTCAON or HSTCANB Algorithm:First the connector check the Substitution List to find if there is any substituted tax id for HSTCAON.      

Hi there! Is it possible to override the billing address in an Acumatica Sales Order and then synchronize the updated data back to Shopify?According to the documentation at https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=5196a797-02c0-41b4-a2f3-788347c97990, updating the data in the "Addresses" tab > "Bill-To Contact" section should export the overridden data to the Shopify order if Acumatica is set as the primary system for synchronization. However, this didn't work as expected.

If I set this inventory setting thusly under Shopify Stores in Acumatica: Acumatica will sync the Sales Category to Shopify as a product tag, which is great.However, if you add any additional tags in Shopify, the Acumatica connector will REPLACE them all with the Sales Category tag every time a sync occurs. Which is not so great.Anyone know if it is possible to make the Sales Category tag MERGE with any already existing tags in Shopify instead of replacing them all?

I would like to update the customer credit term assigned to orders based on their customer class with the credit term retrieved from the Shopify metafield.Currently, there are some orders where customer service can create an order for customers who, according to Acumatica, can only pay with a credit card (CC), but they are supposed to have NET 30 terms for this order. The NET 30 term is stored in the metafield, which is mapped to the Terms field. However, the issue is that the data does not automatically override the terms field in the order when it arrives from Shopify. The terms field is only updated manually by the CS team in Acumatica.Is there a way to manage this process automatically by using the metafield data from Shopify and passing it to Acumatica?