Commerce Edition QnA
- 370 Topics
- 1,540 Replies
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
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?
Hi, Acumatica automatically sends the Vendor Ref number on Purchase Receipts to Shopify as the tracking number. Since we’re using the field for what it was actually intended for (Invoice Numbers), can we restrict Acumatica not to send those?
Hi I am settling up a connection to BigCommerce and have template items which are syncing with BigCommerce using the connector. I have attached images to my attributes used in the configuration of my matrix item and would like these to sync with the Variant Options in BigCommerce. Does anyone know if this is possible please? Thanks Matt
Is it possible to automatically add a non-stock item when a specific sales order type is selected/created? For example, we would like to be able to have a non-stock item automatically added to orders from a specific channel to make sure promotional materials specific to that channel are included in the shipment.
When an order comes in with both products and gift cards how are you all handling them in the ERP?We have been marking the gift cards as complete before creating shipment (since Shopify sends the digital GC and our shipping department has nothing to scan or send if we don’t), but we are seeing that in doing this the gift card is not being added to the invoice and therefore is not being paid in the ERP. Also, Acumatica is then only capturing the invoiced amount sans the gift card payment.How should we be doing this so that the correct money is being collected and the ERP is showing the GC sales?
We have a client that needs to implement Stripe so payments from events can be uploaded automatically into Acumatica under a general Customer ID. Then these transactions would be offset against a project under the Projects number and Project Task. Do we need to get a connector through an ISV for this? I know Acumatica has a license feature for Stripe. Any insight would be helpful or instructions?
Be default, commerce connector merges customers from external systems using the same email address. i.e. when you have two or more customers from one or more stores irrespective of the connectors(Shopify, BigCommerce etc.,) imported into Acumatica, the connector creates one customer record for all.But because of some business scenarios if this is required to not to be merged and create separate customer records, then this could be done using the attached customization. Once the customization is published, you see a new checkbox called “Merge Duplicate” in Entities(BC202000) form. If checked for the stores for the customer entity, then customer records from different stores would be merged and you would have one customer per email ID. If checked for few stores and not for all, then checked stores will create a separate customer records but unchecked stores will share a common customer record.
Hi everyone, I just have a question.Do B2B Bigcommerce supports Sales Prices sheet, customer specific discount, qty discounts on a line item level, and order level discounts from Acumatica? I just want to make sure that everything how it is currently operating in Acumatica, can be replicated in BC. or whether TranZetta pricing will work. Thank you.
A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica. Instead the just want to have each variant as a individual SKU in Shopify. The Shopify help says to delete the variants and the default. They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs
Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!
I need to map the phone number associated with the default address from Shopify to a specific field in the customer record in Acumatica, but I can’t seem to figure out how to specify the phone number associated with the default address, not the phone number associated with one of the other (non-default) addresses, in a formula in the Customer entity.Does anyone have a suggestion regarding how to accomplish this?
When I got into the template item for a product we sell and try to delete one of the matrix items that we no longer offer I am getting an error. “Referenced in multiple tables”. The trace points to a number of locations including old sales orders and GL accounts entries. Is there a way to keep the references in the tables but remove from the matrix? (we use matrix to push to a number of ecommerce solutions our current work around works with some and not all)
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?
Hello, We have noticed after creating a sales order that a duplicate is now showing up. It has all the exact same information. Same Reference number, same shipment number, same payment information. I added a note to one of the orders and it showed up on both orders, so they are linked together somehow. Therefore, I don’t want to try and just delete one, since it will most likely delete both. However, when I look at the customer account, only one order shows up. Does anyone have any ideas on how to address this duplicate order issue? Thank you!
Hey everyone, I’m currently working on this error and trying a few different things on the Shipstation Configuration settings as well as the the Acumatica to Shopify Entity settings. I’m not seeing it at all on the community so I figured I’d post it here while I work on it. If anyone has any suggestions, please send them my way. This shipment cannot sync due to this error. It seems to only be an issue on a handful of shipments but it’s possible that this might be a continued error. “Error on errors : All fulfillment orders must have the same delivery method type. Multiple delivery method types ["none", "shipping"] were found.;”
Hi I have non-stock template item kits set up which are picked and packed at point of order. This works great when I process the order in Acumatica. When the non-stock item is pushed to BigCommerce it is allocated as a Digital item and not a Physical and therefore does not have the associated shipping process and can be ordered without the need to input an address or select shipping options. If I manually change the item in BigCommerce to Physical, the resync from Acumatica overwrites this. The non-stock items have Require Shipment flagged on them. Is there a way to have non-stock items sync as Physical? Many thanks Matt
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.
In this article I will show you how to configure Acumatica to automatically accrue Gift Certificate amount. Step 1: We need to create a new GL Account that will hold sold Gift Certificates value. Step 2: We need to create a corresponding Cash Account that will be used for the payment by gift Certificates. Step 3: We need to create a Payment Method that will accept payments by Gift Certificates Step 4: Now we need to create a Non-Stock Item that will represent a Gift Certificate item in the Sales Order. Please note that we should use Customer Gift Certificate GL Account as Sales Account in the Non-Stock Item settings. Step 5: We need to configure BigCommerce or Shopify to handle Gift Certificates payments and associate a Gift Certificate Non-Stock Item: Step 6: Place an order with Gift Certificate at BigCommerce/Shopify. In this example I’ll buy 100$ certificate:And proceed with checkout. Step 7: You will receive a Gift Certificate at your email address. Step 8: Synchronize the Sales Or
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.