Retail Edition QnA
Shopify Payments syncing has been working great. However, we had our first backorder on a Shopify Payments order. The authorization from Shopify within Acumatica was captured for the amount of the order minus the backordered items/freight. We received the goods in to ship, but the authorization no longer had a balance even though we did not capture the full amount. Well in Shopify, you can still capture the balance. So we did. However, that second payment is not syncing to Acumatica so we cannot apply that payment to the shopify order/invoice. What are the plans to address this? Back ordering is common in our industry and we want to allow that for web orders. We can try to create a manual payment to mark the order/invoice as paid in Acumatica. But, that is not a real solution. Thoughts?
Have been getting the above error whenever I try to sync the prices to be exported to Customer Groups from Acumatica to BigCommerce.
Recently Shopify released a new app for selling Bundles on Shopify eCommerce sites. Multiple customers have reached out with questions about if this feature will work with Acumatica’s native integration.The quick answer is “Yes!” - and it’s pretty easy to configure and leads to great results.Below is an introduction to the solution as well as steps for configuring your Shopify site to sell bundles, then automatically importing those orders into Acumatica for easy picking and packing.Use CaseA merchant sells 3 individual items on their Shopify site They found that their customers typically buy 2 of the 3 items at the same time. They decide that if they sold all three of the items together into a bundle with a discounted price this may lead to more revenue and higher customer satisfaction. The merchant does not want a unique SKU that represents the bundle. Instead, they only want to maintain the individual item SKUs. Plus, they need to be sure that the bundles inventory is based on the q
We have just come across this issue having been using Acumatica with Bigcommerce for a couple of years. We have a promotion for an item XYZ which means a discount is applied when ordering 12 or over. We have also added a promotion for that same item when bought with another item ABC where it will be discounted by 2%. In BigCommerce this results in 11 items at the reduced price from the dozens discount with 1 item at a further reduced price from the ‘buy with item ABC’ discount. This is fine and as expected. Our BigCommerce store in Acumatica is set up to show discounts at the document level.The problem is that when the item syncs to Acumatica it results in multiple lines for item XYZ. One for the first 11 and another for a single item. These show the same price (the reduced dozens discount price) for both lines as the discount is being shown at the document level.I would expect as the discount is being applied at the document level these would be combined. This is causing extra wor
We currently have the Shopify Connector setup and want to start using the Shopify POS. I don’t see the Shopify and Shopify POS Connector option or Custom Connectors option in our production environment, just the Shopify Connector option. We have the Distribution Edition and added Shopify. We don’t have the Commerce Edition, I’m wondering if that is why, or is it just a completely different license and it’ll be added after we get a difference license that includes the POS Connector?
We’re trying to set up the Outlook Extension for Accounts Payable bills. Has anyone run into this issue where it doesn’t work for shared folders? I guess the extension needs to be engineered to accommodate shared folders. Is there another extension out there that accommodates that?
Hi Team,We are working with Build 23.112.0032 and working on a customization where we have to add an image url ( https://xyz.s3.amazonaws.com/kkltQWuXULPcHQ6TmoMsZkiJOK93x8.png) as File attachment to a Sales Order record through code. We tried to insert this image url under Name field in UploadFile table and later to map this record along with Sales Order NoteID under NoteDoc table but we are facing issue with approach. Can you please suggest the best possible way to achieve this. Thank you in advance!
Acumatica allows us to create Unit Of Measure Conversions, which is extremely helpful. It allows clients to sell the same item as an ‘each’ or a ‘case’ and counts it as 1 item which can be differentiated in the cross reference as 2 separate barcodes. So the warehouse can scan either the barcode on the individual item (the ‘each’) or the barcode on the case of 4 (the ‘case’). In Shopify & BigCommerce you are not able to create Unit of Measure conversions. You are required to create a variant for the each and the case instead. With this in mind how can these 2 differences still work with the commerce connector? It appears to me like I may be forced to have my client create 2 separate stock items in Acumatica, then create a Template item, plus new attributes, then add them to the Item Class, then add these 2 items to the Template item, as well as require them to maintain 2 separate inventories for the same 1 item moving forward just so they can sell it as an ‘each’ or a ‘case.’ I hope
Hello, as you know Acumatica has a commerce connector with shopify. I read documentation but I did not find if there is a restriction with versions of shopify, do you know if acumatica is compatible with any version?
We need advice on what Acumatica security rights we must ive to third-party developers of our Dashboards and Business Events. We would prefer not to give them “admin” rights if at all possible. We prefer to give them the minumum rights possible to create dashboards and business events and nothing more so our system is safe. Your suggestions are greatly appreciated.
Is it possible to lock down the editing permissions for Bills & Adjustments (view only) except for those Bills that they're assigned to be an approver of? For example, we'd want them to be able to change the GL Account, add lines, etc. but we don't want them to do that for Bills outside of their department. I feel like that's probably a standard capability, but I can't figure out how to get the access rights to do it that way.
When exporting orders from Acumatica using the Shopify connector, it is requiring that the sale be > 0. Error on order : Transactions is invalid; Error on transactions : Amount must be greater than zero for sale transactions We use Acumatica to create replacement orders, giveaways, affiliate orders that have no revenue. Acumatica makes it easy to use Reason Code, plus it’s quicker to order from Acumatica than Shopify. We would like these orders to be in Shopify so the customer can see the history and so our 3PL can fulfill those orders using our current workflow. Has anyone experience this or know of a work around, other than creating the order in Shopify.
Just need to clarify - does the ecommerce connector support syncing a stock item attribute to a product variant metafield in Shopify? Or does it only support syncing to a product metafield?
Hi all,The Commerce Retail team has recently introduced the Product Import feature, and in this topic I would like to share how vendor details from the Vendor field in a Shopify store map with the Vendor tab in the ERP when we use product synchronization in import (bidirectional) direction. In the screenshot below, you can see an example of successful mapping when the XIANGTAN Apparel from Shopify matched CONXIAN vendor ID with the same vendor name "XIANGTAN Apparel":To import vendor details into the product, users need to create the vendor inside the ERP using the vendor name in Shopify as Account Name for the General tab of the Vendors (AP303000) form in the ERP. A vendor from the Shopify store will be imported into the product only if its name matches (case-insensitively) to the Account Name of the vendor:If the name of a vendor from the Shopify store does not match any Account Name from the General tab of the Vendors (AP303000) form in the ERP, the vendor from the Shopify store wil
This feels like an answer that should be found in the help articles, but I can’t find anything. How do we set the character limit for an Attribute of Control Type Text? I’m trying to import to an attribute and got this error:
Customer invoices are not automatically getting recorded in the Customer’s Profile under “Activities”. We have CRM if that matters. Should customer invoices automatically be recorded in Activites? If not automatic, how can we get the customer invoices to be recorded in Activities?
BigCommerce:eCommerce Admin can choose how the customers should checkout in BigCommerce as shown in the below screenshot. If the customer decide to checkout as guest a customer account will not be created in BigCommerce. So in Acumatica the Sales Order will be imported with Generic Guest Customer provided in the Store Settings as shown below. If a customer decide to checkout with account details, then a customer account will be created in BigCommerce. And in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers are allowed to checkout as guest but BigCommerce will create a customer account as soon as the order is placed and in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers cannot checkout as guest in BigComm
Why do we not have the option to override the ship to address on invoices? We actually receive many requests from our customers to change the ship to address after the invoice has been issued. Why was this capability removed? When we first launched with Acumatica we were able to change it.
Hello,I was recently informed by a client using the Shopify Commerce Connector that confirmed Shipments are now syncing the Acumatica Ship Via to Shopify and displaying it only in the Shopify Shipment Confirmation email being emailed to customers. Their Ship Vias make sense to their team internally but is causing confusion/concerns with customers receiving emails notifying them their Shipment was sent via the “Cheapest” shipping option. I could not find a way to unmap this using the entities mapping for Shipments or Sales Orders. Is there a way to unmap this from being exported? Or any potential workarounds?Thanks!
I frequently receive inquires about the details of how payments are handled between eCommerce platforms and Acumatica. Below are details about this topic. Common eCommerce Merchant ProfilesWe see 2 primary types of Merchants who are selling via eCommerce and managing their back office via Acumatica.B2C/D2C Merchants Often, individual orders are small. B2C/D2C merchants rarely sell items which cost more than $2k Most Consumer purchases are done with a CC Sometimes merchants allow buyers to place an order, pickup/pay in store B2B Merchants Orders are typically larger Common to see orders which total at $5k - $30k Some buyers want to use CC for payment, or it's a requirement of the seller Many buyers will prefer to pay by check via NET30/NET45 Terms Rule of Thumb - best to not try to guess at how merchants will want to handle payments. Every merchant is different, and it's not an area where they are flexible. Goal is to make the technology as flexible/extendable as possible to acc
Since upgrading to Acumatica 23R2 from 22R2 we are getting occasional sync errors saying:Object reference not set to an instance of an object.when syncing new orders from Bigcommerce to Acumatica. I’ve looked at the trace but I’m not really sure how to troubleshoot this error.The external orders also don’t look any different to ones that are syncing without problems.If anybody has any ideas that would be very helpful.Phil
Hi All, Not sure if anyone can help (Even just to confirm). We have setup the acumiatica with BigCommerce conector. For the most part it has all been tedious but there seems to be a short fall in the amount of attributes you can/not sync from acumatica to Big Commerce. ONe specific that comes to mind is the matrix/variant attributes. Specifically we wanted to send across the matrix products width, depth and height AS per acumatica: There doesnt seem to be any defaults for anything of these. Thanks,,Ben.
I am having trouble controlling sales of different matrix items. We sell both on Shopify and enter order directly in Acumatica, so the item status field is important when we need to shut off sales. Most of our items are set up at template items, each template has different package sizes. We often have to set the item status to “No Sales” when we are sold out of a package size.When we have to turn off multiple matrix items under the template, it often times fails in the sync to Shopify saying “No matrix items are generated”. This is turn does nothing on Shopify and will allow sales to come down on items we are sold out of.Has anyone else experienced this issue with the ecommerce connector? Ideally we want to have template items so we can have multiple options on one product page, but we want to control each matrix item like it is a single stock item.
Any developers here? Do you know the logic of Ship Via import from BigCommerce in 23R1?We have this weird scenario, where if an order has a shipping method in BC that is not mapped on the BigCommerce Stores > Shipping Methods screen, Acumatica will not throw an error on import, but will use a UPSGROUND shipping method.We used to have a formula in Sales Orders entities screen for Ship Via, like this:=iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Ground')<>-1,'UPSGROUND',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Standard')<>-1,'UPSSTD',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Early')<>-1,'UPSNDAAM',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], '2nd Day Air')<>-1,'UPS2Day',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Next Day Air')<>-1,'UPSNDA',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Express')<>-1,'UPSWWEX
I’m really new to Acumatica and the documentation is very sparse. I’m trying to export stock items to Shopify and facing this random error. Even if I haven’t mapped the weight_unit field. I’ve scoured the forums and the web and came up dry. I followed all of the instructions in the guide and it still isn’t working.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
