Retail

We use Template Items in Acumatica with Matrix items by Condition (New, Used, Refurbished, etc.). We really only have one attribute but we are required to use two in Acumatica in order to generate the Matrix items:  However, when the products sync to Shopify they sync both attributes as two different variant options: The 2nd variant option (in our case, “Condition Level”) is not necessary for us and shows up on the product page, which we do not want. Is there any way to unmap this specific variant option in the connector? Or another method to prevent this from syncing to Shopify?

We would like to be able to show a more formal description for each Matrix item on the BigCommerce site. Right now when you select a template on the BigCommerce site and then choose your variant options, the only fields that are displayed about the selected Matrix SKU are the image, the price and the SKU ID. The description for the item is simply a reiteration of the variant options selected on the checkout page, and nothing more. We would like to have the fill item’s description shown in Acumatica for that Matrix item displayed along with the SKU ID on the main page and the cart. When looking at the BigCommerce backend, we do not see a specific field for the description on the SKU columns. There are Bin Picking Number and UPC/ISBN as fields to be displayed, yet nothing in Acumatica found syncs to those fields.Does anyone have any suggestions on how to show a more detailed description of the SKU when the variant options are selected on the template?We are using Acumatica version 2023R1

We use Big Commerce as our website (and Acumatica 2022 R2).  Is Google BigQuery part of or easily installed into Big Commerce?  

I've set up a connection between my Shopify and Acumatica systems. When a customer placed an order and made a payment, it resulted in the creation of an order (SO.30.10.00) and a prepayment (AR.30.20.00).However, today, the customer decided to cancel the order. Now, when I check the 'Sync History,' I've encountered an error message stating, 'The applied amount cannot exceed the unbilled balance.' What might I have done incorrectly? Why is Acumatica preventing me from syncing this transaction?P/S   Acumatica version = 2023 R1Build 23.111.0019 

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.

Context: Allowing preorders for BigCommerce products (stock items). We’re currently on 2020 R2 (updating to 2021 R2 in the next 90 days) and on the BC Enterprise storefront. BigCommerce Requirements: To properly allow the native ‘preorder’ functionality to work on BigCommerce, two settings need to be adjusted:‘Availability’ needs to change to ‘This product is coming soon but I want to take pre-orders’ ‘Inventory Tracking’ method needs to change to ‘Do not track inventory for this product’Acumatica Settings: At the individual stock item level, it is possible to adjust the ‘When QTY Unavailable’ setting within ‘Inventory Settings’ to ‘Set as Pre-Order’. Sounds great. Acumatica Behavior: This ‘Set as Pre-Order’ action only adjusts the BigCommerce ‘Availability’ setting to the required ‘This product is coming soon but I want to take pre-orders’. However, without the ‘Inventory Tracking’ setting getting updated in tandem, the action of allowing pre-order isn’t actually achieved. There are o

Anyone know how to prevent note synching between Shopify <> Acumatica? I assumed it was possible through the Sales Order entity > Import Mapping, but that doesn’t seem to be working.I’ve tried both of these options to no avail: We use the Notes field in Acumatica extensively and we have instances where the order resyncs with Shopify and the Notes are overridden, so we are trying to prevent that from happening.

Does anyone know if the ProGlove Mark 3 scanner is compatible with the Acumatica mobile app? https://proglove.com/products/hardware/mark-3/

Hey everyone, I’m currently working on this error and trying a few different things on the Shipstation Configuration settings as well as the the Acumatica to Shopify Entity settings. I’m not seeing it at all on the community so I figured I’d post it here while I work on it. If anyone has any suggestions, please send them my way.  This shipment cannot sync due to this error. It seems to only be an issue on a handful of shipments but it’s possible that this might be a continued error. “Error on errors : All fulfillment orders must have the same delivery method type. Multiple delivery method types ["none", "shipping"] were found.;”

On a number of our clients’ Shopify stores, we can’t access Acumatica App, getting this error: This happens in Google Chrome, Mozilla Firefox, and Safari.  Tried on Windows and MacOS.Any thoughts, @KarthikGajendran , @smarenich ?Thank you!

Can I configure the Acumatica Connector to sync our Customer Attributes from Acumatica to Big Commerce? 

Two core settings in our Big Commerce website have mysteriously reset.  One is “Track Inventory”.  Our system is set up to track inventory and so when stock goes to zero, the item is automaticsally removed from our webset and when we restock the item the item is automatically returned to the website.  The “Track Inventory” setting was “unchecked on hundreds of items and hundreds of out of stock items reappeared on our website.  Two, some of our items are set to “do not sell on the website” and instead “Call for Pricing” appears under the item.  All of these call for pricing items were reset and the “do not sell” box is not checked. And the Call for pricing has disappeared.  We are on 2022 R2.  What is happening?  Big Commerce has not idea what is causing this to happen.  Can anyone help us? 

Does anyone have any experience using SQUARE POS? We have a Retail Store, BigCommerce site and we use Acumatica as our ERP. I would like to start using SQUARE for our POS.

Good afternoon Acumatica community! We are hoping to get a question answered about the sync between Shopify and Acumatica for the Payment entity.We have one Shopify store connected. Every Entity other than Payment is syncing as expected. We are using ShopifyPay to process CC payments for orders through our website. At the tier we’re on, ShopifyPay charges 2.6% + $0.30 per order.This information doesn't seem to be imported into Acumatica for us at this point. The payment comes through like this:Image pulled from the Sync History (Commerce module)Image pulled directly from the payment entry generated by the sync We are sure the system is capable of importing the fee information based on the following screen shot from Shopify’s backend. Our VAR advised us to add Shopify’s fee manually later in the process, but this is cumbersome and ultimately not scalable. We are looking for advice about where to add these fees (potentially in the payment methods of Acumatica?) If someone has done this b

When we are in the sales categories, we do see all items and template items associate to each sales categorie, but we can’t have access to templates items when we click on the link. We only have access to stock items.When we click on a template item that appear in the sales categories, we got a blank page associate to sotkc item IN20500. It seem like there’s a problem or a bug.It would be more efficient if we could also have link instead of having to open another tab and make another search.

We are exploring the use of Shopify as a gateway to import orders from TikTok Shop into Acumatica. TikTok has finally started developing their own solution for this but it is lightyears behind other social media shopping channels. Does anyone have any experience in this area yet?

Hello folks,I was wondering why RC order type was chosen as the only supported return order type for the Commerce Connector? It seems like RM order type would be better suited, as it allows for issues and for receipts, credit memos and invoices, it’s more versatile. One of our clients said:The reason we prefer RM is that this Order Type allows both Operation types: Issue & Receipt AND it allows for an Invoice.The other two types are more limited.For instance, an RC does not allow for things like charging a Restocking Fee (Issue)And an RR allows for an even exchange but not for an exchange where money changes hands (which is 80% of what we do)What do you think about this? Are there any drawbacks of allowing to use RM order type for ecommerce returns / replacements?Thank you!

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; 

The following error is getting shown up whenever I am trying to import the Sales Order which consists partial payment with Gift Certificate ($25) through BigCommerce.  

Does anyone know if it’s possible to have a virtual warehouse/inventory in Acumatica? We receive inventory files from vendors and it would be great to be able to “receive” that inventory into a virtual warehouse so our salespeople can see available quantities from the vendor. In theory we could then also sync that inventory to Shopify so we can prevent overselling on drop ship inventory.If it’s not currently possible in native Acumatica, are there any 3rd party solutions? Or ideas for workarounds?

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

Hi All, Is it possible to have a unique Default Order Type based on which branch or company you are logged into? We have 2 separate companies in our instance. Company A uses Quotes, or QT order type, for 99% of their orders. Meanwhile, Company B uses Sales Orders with Allocation, or SA order type, for a majority of their orders. Changing the sales default sales order setting affects the default for both companies: Is there a unique setting per company or branch that can be used to configure this instead?

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