Commerce Edition QnA
- 371 Topics
- 1,540 Replies
-----------------------------------------------------------------------------------------------------------------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?
Hi,Does Acumatica BigCommerce connector supports Channel Manager?Currently, our customer has two channels in BigCommerce Its my understanding that this feature gives BigCommerce administratros to have 2 storefronts with the same store. Does the Connector has the possibility to separate which products will be exported and used in specific frontstore?Or the products should be configurated in a new BigCommerce store to use a new store in Acumatica connector? Thanks!
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.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?
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 "
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?
How do I troubleshoot Error: Option values ids on update should belong to the option when syncing a Template Item to BigCommerce?
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
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
How to import orders from Shopify for Canadian orders where more than one province has same tax code
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.
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.