Retail

Acumatica 2020 R1, Build 20.101.0032, Screen ID: PO301000 Is there a way to have the Promised On field located within Purchase Order screen default as blank? It currently defaults to the date that the Purchase Order is created. Using Automation Steps, we can change the date that shows in that field immediately after creating a new Purchase Order, but as soon as a Vendor is selected it reverts back to the current date. We do not have any lead times set for our Items - so I’m not sure if that is partially causing this issue.  

  Requirements A company that runs Acumatica and B2B BigCommerce, wants to enable the customer to order in B2B BigCommerce customer specific products at customer specific prices as a temporary ECom order  The company gets the ECom order in Acumatica as a Sales Order  The company may change the item in the SO, may add an item (accessory, required cable, ..), may change the number of units in a Sales Order to finally complete the ECom Order which now has become a Sales Quote.  The company wants to submit that Sales Quote to the customer in B2B BigCommerce  The customer can check out the Sales Quote, accept it as a final ECom Order, and pay for it online  Possible Solution  What is the best solution?  Can this be done in B2B BigCommerce?  If so, how can it be done?  If not, what is an alternative solution?  Transfer the sales quote to the Acumatica Customer Portal for the customer to check it out? Ugly process.  Does B2B Shopify Plus offer a better solution? Thanks for your h

Hi All,In BigCommerce the sales categories are mandatory to create a new item, so that is why Acumatica-BigCommerce connector requires to have at least one category during the export. I would also recommend you to manage Sales Categories in Acumatica, this will simplify the process and allow you to have one source of truth. However, if you really need to manage sales categories in BigCommerce only, I can suggest you the following customization that will disable categories synchronization for existing items. Only new items will still require at least one sales category: Step 1: Go to Item Sales Categories screen (IN204060) and create 1 category with name “Unassigned”. Name can be anything, Unassigned was used just for example. Step 2: Go to BigCommerce Stores (BC201000) and used Unassigned category as the default Stock and Non Stock Item category. This will allow you to export a new item created in Acumatica to BigCommerce without any error. Step 3: Publish the attached customization “B

Hi everyone. Is there a way to sync SKUs with the same descriptions from Acumatica to the Bigcommerce?

Hi,  We have a requirement to parse CustomerMessage string in mapping while importing Sales Order from BigCommerce to Acumatica. For example, we have customer Message string like this :” abc test some | PO Number : 123243 ”I need to get this  value “123243” in one of my Acumatica Field.Can someone suggest how to achieve this? Thanks,Shikha

Hello Acumatica Community,We have released the latest AcuPOS powered by IIG for 2021R2 & 2022R1 2021R2 Build 207R06 - Build, Help Section, User Guide, & Release Notes 2022R1 Build 106R01 - Build, Help Section, User Guide & Release NotesThis information can be found Community >Product Downloads > Add-ons and Integrations > Acumatica Point of Sale (POS) powered by IIG

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.gotowebinar.com/register/2548202183370254095 Feel free to share this invite with any colleagues that you see fit.  Look forward to having you on our webinar.  Thanks,Ryan

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 eCommerce API object to Acumatica API Object. [PXOverride] public void MapBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod) { baseMethod(bucket, existing); foreach (var detrow in bucket.Order.Extern.NoteAttributes) { if (detrow.Name == "Amazon Order Id") { if (bucket.Order.Local.Custom == null) bucket.Order.Local.Cu

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:Any help is appreciated!K2

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: