Retail

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

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 wh

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 

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?

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

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.gotowebi