Retail

Is there a standard data processing rate for stock items when syncing updates from Acumatica to BigCommerce via the native connector?We have over 150,000 SKUs in our database and we often mass update pricing for a large % of our items. The current rate we’re experiencing is only 5 items per minute. At this rate, it takes us 21 days to upload our changes to BigCommerce if we’re mass updating pricing on all records. Is this standard behavior or should performance be better?

Hi Team,I have created a custom field on Customers screen. Is there any feasibility to get this field under Field Name drop down, under Export Filtering tab, on Entities screen, for Customer entity. To control the customer export based on this checkbox.As if this checkbox is checked, those customers only should Prepare & Process. This I am trying to achieve on build 20.221.0021.

Our shipments in Acumatica are updating our BigCommerce sales order to a status of shipped.  If we cancel the order in Acumatica can the sales order sync the BigCommerce sales order to cancelled? 

Hi Team,I am trying to sync note_attributes value through mapping but it is taking first attribute value and I want to have second attribute value. Can anyone please suggest how we can achieve this, please find details info below:note_attributes value in Shopify order json (shared full order json in attached text file)."note_attributes": [      {        "name": "Language",        "value": "en"      },      {        "name": "PO #",        "value": "PO number test"      }    ]Mapping used in Acumatica to sync the value under Customer Order Number field.Getting first attribute value but want to have second attribute (PO #) value.

Hi everyone.We have the goal in our BigCommerce store to have a multiple small sales order and have it in one shipment so they can avail the free shipping level we have. The customer wants to have their: Multiple Orders - One Shipment - Bill them separatelyIs it possible in acumatica? Thank you in advance.

Hi everyone. May I ask how I can have qty on hand in my inventory using my test account in acumatica?

I guess this is a question more for Acumatica’s product team, but if anyone has encountered this scenario before, please enlighten me as well.Right now in Acumatica, Gift Card is a non-stock item. So when a gift card is purchased in Shopify, the Sales Order is synced to Acumatica with the non-stock item just like a normal Sales Order, so how do we treat the gift card liability?For example, when you sell a gift card to the customer, if you have not redeemed the gift card, the gift card amount is still a liability, until the customer redeems it, then it goes to Sales. But if we treat it as a non-stock item on the Sales Order, it goes straight into Gift Card sales.Is treating a giftcard sale straight away as a sale instead of a liability a correct way to handle it?

I would like to invite you to join our upcoming webinar to gain knowledge and expertise around everything eCommerce. Learn more how you can leverage several advantages for your clients using BigCommerce & Acumatica to grow revenue online for both B2C and B2B businesses. This webinar is designed and dedicated to Acumatica VARs only. You’ll walk away with many resources from this course from essential topics including:  eCommerce fundamentals, complexities and opportunities eCommerce trends and future predictions Why ERP & eCommerce is better together Q&A  Presenters: Sachin Wadhawan - VP of Tech Partnerships at BigCommerce When: Tuesday, June 28th from 2:00 p.m. to 3:00 p.m. CDT Registration link: register.gotowebi

Hello,    I found Acumatica is having add on called “AcuPOS powered by IIG”, which looks like an entrie whole solution for POS and Acumatica integration.   But correct me if I am wrong, “AcuPOS” looks like also requiring the customers switch/change the POS system they are using right now, right?    If the customers prefer to stay with the POS they are now using, Is there any existed way to go?

A store credit is given to a customer manually in Big Commerce.  The customer can apply store credits to their order.  What type of payment method should be used in Acumatica for the processing and accounting?  You would think this is really a discount because you never did a transaction in Acumatica for this.  Even if you created a credit memo on account in Acumatica, this is no way to create a store credit in Big Commerce.

Has anyone else encountered issues with Shopify real time sync after updating to the latest build of Acumatica 2022R1?  We are now getting an error “The push notification definition is not found in the system.” when we try to stop and restart the real-time sync. 

Any possibility of Commerce edition supporting Mfg Product Configurator with commerce sites?

Acumatica Partners: Join BigCommerce on June 28th for our VAR University- Ecommerce 101 session! This course will cover essential topics including: eCommerce fundamentals -  eCommerce trends and future predictions Business-critical eCommerce technologies and solutions eCommerce complexities and opportunities Why ERP & eCommerce is better together for your clients an eCommerce Resource library  Q&ARegister here. Colleen SheaManager, Strategic Partnershipscolleen.shea@bigcommcere.com 

Hi All,In case you have such additional details in your Shopify order and you want to import it into Acumatica with custom field, you can do it with a simple customization.In Shopify, this data is stored in something that is called Note AttributesBut unfortunately, this data is stored in the Key/Value pair, so it is not easy to map it using the mapping engine.But we can write the mapping using the code:public class SPSalesOrderProcessorExt : PXGraphExtension<SPSalesOrderProcessor>{ public delegate void MapBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing); //MapBucketImport is mapping the eCommer

A client has two web stores being synced to the same Acumatica tenant. One store, B2B only, will only use customer group pricing (AR Sales Prices by Customer Price Class) with a fallback to Default price and the other will use the Default pricing with occasional specials.  The default price in a Big Commerce store can only be updated from the stock item or template item. The client wishes to update the default price on the B2Cstore using AR Sales Prices because the price may be different from the stock item default price for the B2B customers. Unfortunately the Base Price and Price List entities do not allow Export Mapping.Has anyone had this issue and how do they resolve it?  Is it even possible to customize the sync process?

We need to map an attribute to the BC default price.  For non-matrix items we can do that.  When syncing the template does the process use the Stock Item mapping or does not sync use the template mapping and uses the stock item data?

Sorry if this is a duplicate post, but I couldn’t seem to find the right answer…Hello,Looking to see if anyone knows how to reference Shopify Tags on the Commerce Connector.The screen in Sales Orders has space for shopify tags: In my Sales Order Entity (commerce connector) I want to pull in the TAGS from the SHopify order, but I don't know the SHOPIFY syntax for doing so, assuming it’s the [Keyword]:[NameSpace] or [Value] setting:

Hi. Is anyone can give me an advice on how to get customer specific pricing out of Acumatica via API?

As per the V200 Manual:  

The question is regarding taxation of digital goods sales.In BigCommerce, you’re not required to provide your shipping address if you’re only purchasing a digital good (eBook, for instance). Therefore, your order looks like this:You may notice that Avalara still calculates the tax, based on the billing address (which is correct).However, when this order comes into Acumatica, there is no shipping address, the Ship Via is set to Will Call, and the tax is calculated based on the Warehouse location (which is WA, in this case).What is the best approach to manage these cases?Thank you!

when I preparing the sales order it showing the following errorInserting 'CA Transaction' record raised at least one error. Please review the errors. FinPeriodID: 'Post Period' cannot be empty. 

Hi. Any thoughts why Customer/Company Payment Method was setup as Purchase Order but in the Acumatica the payment was tagged as Prepayment?  We’re using B2B Bigcommerce. Thank you. 

I’m curious if there is any direct documentation about utilizing the commerce connector and various entity settings at different Acumatica structure levels, primarily Tenant vs Company. Most of the existing documentation appears to center around configuring a single BigCommerce or Shopify store to a single tenant but, for example, what are the options/limitations around connecting store 1 to company 1 and store 2 to company 2, within a single tenant?If anyone has explored this configuration or is using it currently, I’d be interested to understand how it’s working for you and any issues encountered. 

I have recently upgraded a client that was running big commerce connection in 2020R2 with no issues after the upgrade some of orders get this error message but i have not been able to narrow down what causes this problem it seam random to me.“An error occurred during processing of the field Applied To Order value 759.04 Incorrect value. The value to be entered must be less than or equal to 0.0000”i have no idea what field is trying to be updated. any help would be much appreciated. 

i am getting error when i process sales order ERROR:The sales order could not be imported because the combination of the New York State store shipping zone and the None store shipping method is not mapped to a Ship Via or the mapping is inactive in the store settings.