Retail

We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”.  Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced.  We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area).  Is this method the prefered way sync?  Should we stop using the “Sync” button in the “Commerce / Processes” area?  

The current Acumatica Shopify Connector doesn’t process the shipping information during Sales Order Import. But in some cases, Shopify Order will be fulfilled by other 3rd party service, and you want to import the shipping information into Acumatica Order if the order has been fulfilled. This request can be resolved by using customization project:namespace PX.Commerce.Shopify{ public class SPSalesOrderProcessor_Extension : PXGraphExtension<SPSalesOrderProcessor> { public delegate void SaveBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing, String operation); [PXOverride] public virtual void SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, String operation, SaveBucketImportDelegate baseMethod) { //Local is the API Object from Acumatica SalesOrder localOrder = bucket.Order.Local; //Extern is the API Object from Shopify OrderData externOrder = bucket.Order.Extern; //You can check FulfillmentStatus and Fulfillments object to ensure

I have been asked to enable updates from Acumatica to BC when Sales Prices are updated using Sales Price Worksheets. We have several customer price classes in Acumatica (RET, WHL, 1STWHL, GUEST and Base). Any changes to prices for items made that day are updated every evening with a price class worksheet for each of these Price Classes.We want these updates to propagate to the sales price  in BC automatically.In BC we have Price Lists for:WHLRETGUEST (inactive currently)and Customer Groups for : 1STWHL, WHL, RET, GUEST Is this something that is built into the BigCommerce Connector?  I am a bit confused.  I opened the Entities screen and see a Price List option.Do I simply make this active and then do a manual sync? I also see in the Push Notifications that there is BC-PUSH-Prices.  If I open BC-PUSH-Prices and check the conditions it seems to be linked to AR-SalesPrice which is what I believe the Sales Price Worksheets update and in the conditions looking for Entity Type PR but if I ch

Hi Everyone, I need a modifier (dropdown type) in some of the Items in the Bigcommerce that should came from Acumatica. I only know how to create a template item and building variants through attributes. But what I need is a modifier that will not create a new SKU/variant when I select the options.Is this possible?I made an example: the one under the category attribute should be the modifier But it didn’t sync in the BigCommerce 

The sync fails on a useless message.Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Hi All. Anyone here who can help me get the right price in the Bigcommerce B2B  from Sales Price in acumatica without syncing the customer price class in the entity setting? Thank you.

Hello Customers and Partners, The Acumatica Retail Commerce team is focused on improving COMMERCE CONNECTOR ERROR messages with recommendations for what to do in each case. We are looking for your feedback on what are the most frequent or challenging errors where we may clarify and provide direction on how best to address.  Please complete this poll with sections for each commerce connector Acumatica Retail-Commerce Team - ERROR Poll Poll includes written and screenshot option for each commerce platform below BigCommerce Shopify  Magento Alternatively, if only a few errors, please comment on this thread and I’ll capture. Thank you in advance for your time. Stacie Jurczak, Program Manager, Retail -Commerce, Acumatica

We are on 2021 R2 with the Big Commerce connector.  Can we configure Acumatica to limit which warehouse the customers can shop from when the customer is shopping in our connected Big Commerce website?

Hi,  Is it possible to create a customization that would allow users to have a better calendar experience for scheduling appointments, somewhat like Google Calendar.

I am getting the following error with an order syncing from Big Commerce to Acumatica.  Any ideas on how I can fix this and get the order to sync?  Updating the 'SOOrder' record failed because data in some field is too long. String or binary data would be truncated.The statement has been terminated.

My BigCommerce sandbox demo site got messed up and I created a new one.  I was able to test the connection satisfactorily, however when I try to do a FULL Prepare and Process for items, sales categories, etc. it doesn’t show any items to export to the new BC site.  I am assuming that there is sync data that needs to be cleared out on all the records. Is there a SQL script to reinitialize the data used by the entities so that they will publish to the new BC site?  Or can this be done within Acumatica? Best, David Eichner, CPA

Here’s an easy one!  There are a couple tables I’ve found in the sample database that I cannot find in the Code Repository.  I’m wondering if they are legacy tables that are no longer used.For example, EPEquipmentTimeSheetDetail and EPTimeSheetDetail.  The only place I find them when searching the entire solution is in a file “Settings except Attachmments.esc”    <Exclude  table="EPTimeSheetDetail" />    <Exclude  table="EPEquipmentTimeSheetDetail" /> Are these “dead” files?  

For some reason the pricing sync for Big Commerce when you have multiple units of measure enabled is to use the base unit and not the sales unit.  This is a major problem because customers build pricing based on the sales unit and not the base/stocking unit.  How do we go about getting this changed?  This is a critical issue for one of our clients. https://help-2021r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=994bc074-79eb-403b-81c4-9545d470a01dLimitations of Sales Price SynchronizationUOM-specific prices: In Acumatica ERP, if the Multiple Units of Measure feature is enabled on the Enable/Disable Features (CS100000) form, you can define a sales price of an item for each of the units of measure in which your company sells this item. However, only prices defined for the base UOM can be exported to BigCommerce.

 Hi all,I tested creating a new user from the website and it failed to sync into Acumatica until that user was added to a B2B company.Any changes made on the B2B side of the company are now over-written by the Acumatica values (tested on addresses and price lists). I see the sync on this is bidirectional, can I use other option on this?Another thing, I have B2C and I was able to use the "Trade Application Application" to signup a new account that created a customer in BigCommerce and a Company in BundleB2B that was able to sync without issues after I approved the company. If we have all new customers sign up for accounts this way instead of the native BigCommerce account sign up this may be the way to do it? There are some limitations on B2C business. any advise? Thank you.

Hi. Anyone knows the needed mapping rules for Acumatica to sync Correctly in B2B Bigcommerce?

Our ecommerce connectivity from Acumatica Ecommerce to Shopify is working fine except for Inventory On-hand qty in ACM into Shopify Available qty. Any idea why this is? 

Hello Everyone, Today we have some out of the box dashboards provided in the commerce module. You can check those from Commerce Sync Monitoring(BC409010) form in the Commerce workspace(attached screenshot).We would like to know if this is useful? Also, would like to have more out of the box dashboards? If yes, what are the dashboards or KPIs you would like to see? Please let us know. We are planning to add different Dashboards that are related to Sync & Error Handling and also that are related to Commerce Sales with respect to Orders, Returns & Refunds, Products, Revenue, Customers. We would love to get your opinion on that. Please let us know what do you think.  Thank you so much!  

Hello,I work for an Acumatica VAR and currently studying for Shopify installation. However, when trying to implement the connector it is asking for a public address and I’ve only got a local install, any workaround for that ? Thanks

in the image under the internal tab there is nothing. For the other entities pages it works just fine but for shipments it doesn’t. Anyone know why this is and how I could fix it?

Why does the RC function in sales orders have a create shipment button if it's just a credit?

Recently updated to the build 21.216.0034. It would appear there has either been some change to what triggers a ‘Product Availability’ sync request, or otherwise a related bug. In previous builds, ‘Product Availability’ record prepared of course based on update to the given inventory ID (Template, Stock, Non Stock). Expected and documented functionality. Since our update to this build last week, it appears that nearly all Inventory ID records are entering the prepare/process queue, even though the majority of those records have not been modified by any expected action (ie, sales order created, PO received, inventory adjustment, etc).  Is this a known situation? Have changes to what triggers a product availability request been meaningfully changed in this build?  Why this matters in our integration: We override the ‘track inventory’ setting for BigCommerce products that we want to allow backorder on (ie, take an order for something not in stock). For items with low velocity, the Invento

I have encountered a lot of errors while syncing sales orders from bc, I fixed some but this one I don’t know how to fix. Can anyone help me to figure this out?

Hi ,Requirement: map the fields from acumatica to Big Commerce in Entities screen.  In the above screenshot I changed “source field” values. I want to get details from Export mapping tab .where will I get this information and where can I write the code for this.

Today in Acumatica, when Sales Orders are processed into Shipments, the system will by default process based on a limited set of available filters at the Sales Order document level. This method involves the assignment of inventory (SKU’s) generally based on the date ordered. SKU’s that are not available may be back ordered and processed into a separate shipment at a later date. This method appears to assume that all SKU’s on any given order are available or will be available in the short term to fill all open orders. It also appears to assume that companies who wish to capture payment prior to shipment would process the payment on the Sales Order regardless of which items may have been shipped or back ordered. Example scenarios where the current process may fall short.Companies engaged in B2B and B2C sales where priority may be given to one customer type over the other based on a variety of variables. Companies selling limited availability items which need to be distributed across the

Does Acumatica support to automatically import files from my vendors (on daily/hourly frequency) with tracking details for the our POs, and based of that to create a shipment to the associated SalesOrders dropshipped line items? I guess this is very important for anyone that has BigCommerce connector and/or Amazon connector for FBM orders, in order to get the tracking out to the SalesChannel. Also this should add the real shipping cost for that line item, to calculate accurate profit analysis. The tracking file from our vendors contains:PO Number, VendorSku, Shipped Qty, Tracking #, Carrier, ServiceLevel, Fright Cost @smarenich @josh.fischer