Retail-Commerce

Commerce Edition QnA

  • 343 Topics
  • 1,366 Replies

343 Topics

L
Freshman I
lawsontFreshman I
asked in Retail-Commerce

Template Item Sync Error: Shopify supports only up to 3 product options.

Hello,I’m launching on Acumatica and trying to sync Template Items with an existing Shopify store with the same products in it already. I’m hoping to sync them up with each other. However, I’m receiving this error each time (below). Please let me know if anyone has encountered this or knows what the remedy is. Thanks!  Product options could not be created in Shopify. There are 1 variant types in the MISIML template item, but Shopify supports only up to 3 product options.

4
S
Freshman I
3 days ago
M
maneeshau91
asked in Retail-Commerce

How to - Filter the categories on BigCommerce Store screen of Default Stock Categories field

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

0
M
6 days ago
L
Freshman I
lawsontFreshman I
asked in Retail-Commerce

Auto-Increment Template IDs

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! 

1
N
Acumatica Employee
6 days ago
M
Varsity III
mikehoVarsity III
asked in Retail-Commerce

Order types for export to Shopify

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?

5
Yuri Karpenko
Pro III
10 days ago
M
maneeshau91
asked in Retail-Commerce

How To - Update/Assign Date & Time split field value while importing Sales Order from Shopify to Acumatica using Shopify Connector

Hi Team,We are working with Shopify connector (build: 21.224) to import Shopify Orders into Acumatica. We have a date field that we want to update with Shopify order created date time. This field is split on the UI as Date and Time part but is a single field only. We tried like below but the field value is not updating. Can you please review below details and suggest the best possible way to do that. DAC:  #region UsrKNSPSBOrderPlacedTimeStamp        [PXDBDateAndTime(PreserveTime = true)]        [PXUIField(DisplayName = "Placed Datetime")]        public DateTime? UsrKNSPSBOrderPlacedTimeStamp { get; set; }        public abstract class usrKNSPSBOrderPlacedTimeStamp : PX.Data.BQL.BqlDateTime.Field<usrKNSPSBOrderPlacedTimeStamp> { }        #endregionGraph:public class KNSPSBSalesOrderProcessorExt : PXGraphExtension<SPSalesOrderProcessor>    {        public static bool IsActive() { return true; }                public delegate void MapBucketImportDelegate(SPSalesOrderBucket buc

0
M
12 days ago
M
Freshman I
MSwanson86Freshman I
asked in Retail-Commerce

Related Items - change quantity selected in Add Related Items box

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

2
M
Freshman I
12 days ago
J
Freshman I
jvcamachoFreshman I
asked in Retail-Commerce

Create Purchase Request with Non Stock Items

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.

3
Laura02
Captain II
12 days ago
J
Freshman I
jhsu64Freshman I
asked in Retail-Commerce

Shopify Local Pickup Sync Error

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!  

2
J
Freshman I
12 days ago
J
Jr Varsity II
jib87Jr Varsity II
asked in Retail-Commerce

Updating Every Matrix Item Description thru Template Item Description

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. :) 

5
KarthikGajendran
Acumatica Moderator
19 days ago
L
Freshman I
lorachFreshman I
asked in Retail-Commerce

Recording an invoice

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? 

2
L
Freshman I
25 days ago
L
Freshman I
lorachFreshman I
asked in Retail-Commerce

No Accrual account on PO Receipt lines with Service Line Type

I don’t know why when I release a PO receipt that has a line with a Service line type, the accrual account is missing as illustrated below; 

8
kandybeatty49
Captain II
27 days ago
pandachan48
Jr Varsity II
pandachan48Jr Varsity II
asked in Retail-Commerce

Revenue Recognition for Services like Maintenance, Warranties, and Bundled Products in Acumatica

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?

2
ricoybanez
Jr Varsity I
27 days ago
M
Varsity III
mikehoVarsity III
asked in Retail-Commerce

Product availability sync issue: Error on location_id : Required parameter missing or invalid;

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?

3
M
Varsity III
12 days ago
D
dabarca
asked in Retail-Commerce

Will the ecommerce sync for Big Commerce support locations/warehouse mapping?

We are interested in being able to offer BOPIS to our customers but the connector for BigCommerce does not offer mapping for locations/warehouses. The connector for Shopify does.

3
dougmcbride79
Varsity I
12 days ago
Jeff96
Captain II
Jeff96Captain II
asked in Retail-Commerce

Restrict Purchase Receipts from Sending Tracking to Shopify

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?

6
Chris Hackett
Community Manager
12 days ago
MikeBasone
Freshman I
MikeBasoneFreshman I
asked in Retail-Commerce

Client has a WooCommerce store and a Shopify store can you leverage two different native connectors in a single instance of Acumatica

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

3
Yuri Karpenko
Pro III
1 month ago
D
Freshman I
dcobeyFreshman I
asked in Retail-Commerce

Complex Pricing through Acumatica

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   

5
TimRodman
Semi-Pro III
21 days ago
M
Varsity III
mikehoVarsity III
asked in Retail-Commerce

How to specify variant option name when syncing new products to Shopify store

When a new matrix item is synced to Shopify, the Variant Option Name defaults to “Title”.Is there a way in Acumatica to change the Variant Option Name to something else?

7
Yuri Karpenko
Pro III
1 month ago
A
AlexMTN
asked in Retail-Commerce

Override the billing address from Acumatica in the Shopify order.

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.

1
Yuri Karpenko
Pro III
1 month ago
M
Varsity III
mikehoVarsity III
asked in Retail-Commerce

Merge Sales Category export as Product tags in Shopify

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?

5
Yuri Karpenko
Pro III
1 month ago
Jeff96
Captain II
Jeff96Captain II
asked in Retail-Commerce

Tracking Sent to Shopify doesn't Send Email to Customer

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.   

2
Jeff96
Captain II
1 month ago
A
AlexMTN
asked in Retail-Commerce

Ability to override credit terms in SO

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?

1
Yuri Karpenko
Pro III
1 month ago
P
Varsity II
ppowellVarsity II
asked in Retail-Commerce

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

2
P
Varsity II
1 month ago
L
Freshman I
lmayse38Freshman I
asked in Retail-Commerce

Applying Prepaid Rent Pymt.

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.

1
Laura02
Captain II
1 month ago
Jeff96
Captain II
Jeff96Captain II
asked in Retail-Commerce

Product Availability Doesn't Sync with Real-Time Sync

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?

3
Yuri Karpenko
Pro III
1 month ago

Badge winners

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