Retail

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?

When Acumatica sends a tracking number to Shopify to fulfil items on the order, Shopify doesn’t send the tracking email to the customer. I’ve asked Shopify and they said this is an Acumatica issue.   

https://www.acumatica.com/cloud-erp-software/acumatica-retail-edition/acumatica-for-shopify-connector/ Native Shopify integration   Our Shopify integration is built into Acumatica Retail-Commerce Edition – no additional software or 3rd party applications to purchase. Enable users to pay via Shopify Payments from within Acumatica.  Can anyone point me to instruction on how to enable Shopify Payments within Acumatica? From what I understand it is a new feature, one that we have been highly anticipating, but I cannot find any documentation on how to set it up in the community or Acumatica Open University. Any guidance is greatly appreciated. We have been putting off integrating with our Shopify Plus store because we were waiting for more B2B integrations that were expected with 2023 R1. Now it’s here and we excited to dive in.

How do I close out a prepayment of rent. Tenant paid the 8.1.23 rent on 7.31.23 and I posted to the prepayment. Now,I want to close the invoice with payment application.

I can see under the 23R1 documentation that setting the Availability of a Non-Stock item to “Set as Unavailable” is supposed to disable it and make it “not available for purchasing in the online store”: However, I can’t see that anything changes in Shopify when the Non-Stock item is Set as Unavailable; I am still able to purchase the product online.Can anyone advise what the expected behavior is for this setting and Non-Stock items in Shopify?

We are integrating Acumatica and BigCommerce. There are >100k of Stock item records in Acumatica. With that amount, only a subset of products will be exported in BigCommerce based on criteria provided. We noticed that as a default, Export to External is set to true. Is there a straightforward way to achieve our goal where in only the identified items based on criteria shall be exported and the rest will not?Now, what we are doing is to create a GI and make everything Export to External as false, then running an Import Scenario to explicitly set the Export to External true based on criteria given.Hoping to hear your suggestions for a more direct and elegant way on fixing this. Thank you so much :)

Hi, we’re onboarding Acumatica now and would like to confirm this is possible. That is, can we use a Business Event or other functionality in Acumatica to automatically create a 6-digit Alternate ID upon creation of a Stock Item that would serve as a barcode? We would need to it to auto-increment so that it’s unique.