Retail

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:  

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. 

The following error i has getting when do process step prepare data formError: The order currency (USD) does not match the customer currency (), and currency override is not allowed in the customer settings. 

We have a client with multiple locations/warehouses.  They use Big Commerce as a B2B site where the customer needs to be setup first.  They are running into a couple issues I could use some guidance.Is there a way to display inventory availability by warehouse instead of just one specific warehouse or all warehouses? When a customer places an order the customer needs to have the all the items on the sales order assigned to the customer default warehouse, but it appears the integration changes the sales order line warehouse depending on availability.  Is there anyway to force the sale order line warehouse to be assigned to the customer warehouse only?Currently the client is on 20R1, but we are looking to upgrade them to 20R2.Thanks,Kurt

Hello,We are trying to understand the how the refund integration works in Shopify and why we are getting “voided payments” created instead of “customer refunds.”Our Shopify website is setup to capture payments at the sale. When we go to refund an order, we start the process through Shopify and hit the refund button (picture attached) and then we let the integration build the refund. Instead of creating a “customer refund” (which we think we want), the integration has been creating voided payments. What is the logic for how this integration is supposed to work and is there something we can do to have the integration create customer refunds instead?  

Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue)  Cheers!Colleen Sheacolleen.shea@bigcommerce.com Manager, Strategic Partnerships

Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen: May 5, 2022 at 11:00 am PT | 2:00 pm ETLearn how the combination of Shopify Plus and Acumatica:Increased revenue by $90K through back-in-stock notifications Reduced daily order processing times from 5 hours to 1 hour Launched 30+ new products  from purchase order to fulfillment with automationRegister now

Hi.Does anyone here knows:1. API to get template items attributes (color and size, with its options/values)2. API to get how the SKU was generated for product matrix Thank you.