Retail

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.   

Hey folks,Question when going-live and transitioning to Acumatica.  I was testing a few scenarios where I have Shopify orders that are fulfilled/pending payment (not archived).  These orders will be associated to a legacy system order that was already shipped and invoiced.   On conversion we will bring over inventory/qoh and our GL balances, including any open AR.In my test I found the following:    It looks like it bring this order over with an open qty that needs to be fulfilled, the SO In ‘open’ status.  Since our beginning inventory and AR will already account for this, what is the protocol here to make sure we do not relieve inventory of another product (since it has already shipped in legacy). When the payment is received in Shopify it will close and ARCHIVE the order, however it does seem to still bring the payment in, but it brings it in as a prepayment (is this because the SO hasn’t ‘shipped’ in ACU?). What is the overall experience, should we specifically ‘skip’ these legacy

Our Acumatica instance is 23 R1 build 120 and I am trying to override the default URL for Shopify Products using the Custom URL field in the Ecommerce tab on stock items.  When I make changes to this field, the prepare data screen picks them up but after I process data, the product’s URL handle under search engine listing remains unchanged.  Is there something additional that has to be done to make this work?  I don’t think I’m misunderstanding the purpose of this field, given that if I try to include /products/ in the front of the Custom URL value, the system automatically removes /products and leaves a leading slash followed by my custom value.

When we refund Sales tax or a Freight only (no products) in Shopify it creates an RC Sales order and put those refunds in the appropriate places, freight or sales tax.  However with no line items the Sales Order cannot create an Invoice.  If a CM Order type is used, it does activate the Create Invoice button, but then gives the error that no AR Transactions were found in the system.  However this isn’t exactly true because it will should create ARTran lines for Freight and Sales Tax Payables.Current work around is to add a line with a quantity of 1 and 0 Price.  I can create a business event to do this as well, but it’d be nice if it can be handled by the ECommerce connector instead. What other work arounds or fixes do you have?

Hi,  How do I map Ship Via to the correct carrier in Shopify, i.e. I ship something with Estes trucking, I want Shopify to recognize the carrier. 

Are there any retail store operators out there that have a good process for receiving that relies on vendor UPCs to match products on a PO against your Stock Items? Our receiving team struggle to know which product is which amongst our large truck deliveries and they need a screen in Acumatica to be able to scan the vendor’s UPC/barcode and pull up the Stock Item in Acumatica. The standard Stock Item screen doesn’t seem to search through the Cross Reference. Is there a way to change that search function or is there another screen where we can do a quick check?

We are investigating building connectors to Commerce marketplaces.I’d like partners/customers/partners to share with me how they’d rank the following marketplaces in order of priority (#1 highest) and comment on any others that I’m missing.Partners - If you can tell me how many prospects/customers are requesting the marketplaces that will be a bonus. Thank you.Marketplaces and AggregatorsAmazon.com Amazon Business Amazon Vendor Central eBay Walmart Google Shopping Target WayFair NewEgg Overstock Home Depot Channel Advisor Feedonomics SellerCloud 

Team,Just wanted to share some insights on the “Earliest Order Date” that is available in almost of the Connectors from Acumatica. This configuration tells the Connector, the date from which the orders should be brought into Acumatica from the external system and vice versa. Introduction of this configuration helps to define the cutoff date when your Connector goes live. When Acumatica goes through upgrade / any system restarts, it suggested this date is reset to the current date, so Connector does not go and get the old orders once again into Acumatica. This is a point that should be added in your go live checklist for Acumatica upgrades.  By ensuring this date is set correctly before upgrade live, you can avoid lots of old order data hitting your Acumatica and causing sync failures.

Hello! Do any of you use Acumatica for a Print Shop business? Thanks,Kay

We are experiencing an issue on our Shopify, where the connector is manually adjusting inventory numbers by adding a sort of “phantom” inventory available for customers to purchase. This is creating the qty available in Shopify and Acumatica to not be in sync, and creating a lot of backorders in Acumatica. From looking at the different transactions on a given item, there is not return, refund, or assembly being created where it would add a positive value to push to Shopify. Below is an image from Shopify where the connector is adding in a “random” positive value. Some more background information: we only first encountered this issue on items that we are including in a online sale, so the volume of orders coming in for these items increased significantly. Prior to us listing the item on sale, the inventory in Shopify and Acumatica was perfectly in sync, with no error records on the template or product availability in the Sync History screen. I am seeking advice from someone who may have

Hello, On the Sync History screen, I’ve noticed I can search for an individual order or group of orders if I know the External ID or External Description and it loads very fast with no issues. I’m trying to search for a group of transactions from our Shopify store, but group them by their ERP ID.If I search for something by ERP ID, it times out every single time with the error “Request Entity is too large”. I try filtering by Last Attempt date down to just one day, only the Sales Order Entity, only Processed or Ready to Process Status, and still times out. Is there any other way to search for a sync history transaction if I only know the ERP ID and not the external? Thanks in advance!

Team, I will share a troubleshooting step today for a problem which you may have come across regularly.Use Case: Sometimes there is a need to sync the same order multiple times to Acumatica to evaluate different configurations, different entity mapping reflections etc. This is usually applicable on a test environment where you do not want to create multiple test orders to troubleshoot an issue.Steps:Once the order syncs to Acumatica, Connector puts the order cross-reference in the External Reference Number field.   If this reference is removed and then the sync history line is removed.   After this the same order can be synced again.   Repeat steps 1 and 2 to once again sync the same order.  Best Regards,Sathish S

Hi,Im having this error when I tried to process a return:Everything is configurated according to the instructions. Does anybody has any idea why?Thanks!

Hi,  We have an outgoing issue within our Shopify connector, where the customer is not synchronized when the sales order is being created, causing the sales order to fail with this error: “Customer not synchronized, please synchronize the customer entity”, this happens randomly to some orders, not all of them.  In these cases we have to go to Sync History  and manually process those orders. By the moment we do it, the customer is already synchronized (we don’t have to synchronize the customer, I think it gets synchronized a few moments after the order fails)  and the order gets processed, however, this breaks our integration because ideally we shouldn’t have to process any order manually. Is there anything we can adjust to make sure the customer coming  from Shopify is synchronized before the order is created? Thanks, Ruben

We have two Acumatica Tenants.  The first Tenant is our live Production Acumatica Tenant.  The second Acumatica Tenant is our “test tenant” we use to train employees.   Our live Production tenant is connected to our live production Big Commerce Website.  I want to connect our second Acumatica Test Tenant to a second Big Commerce Sand box.  And leave this connection permantly in place to do testing.  Can I connect my Second Acumatica test tenant to a second Big Commerce website Sandbox?  Is there risk of polluting of messing up my orginal live connection?    

I am receiving the error “Attempted to divide by zero” on any order from big commerce that comes in with an item discounted to be $0 on the order. How do I get around this and get the order into our system without manually entering it into Acumatica? Thanks

We have two Acumatica Tenants.  The first Tenant is our live Production Acumatica Tenant.  The second Acumatica Tenant is our “test tenant” we use to train employees.   Our live Production tenant is connected to our live production Big Commerce Website.  I want to connect our second Acumatica Test Tenant to a second Big Commerce Sand box.  And leave this connection permantly in place to do testing.  Can I connect my Second Acumatica test tenant to a second Big Commerce website Sandbox?  Is there risk of polluting of messing up my orginal live connection?    

I am trying to tie together RC order types to related debit adjustments. I can add the relation on the RC under relation on the sales order document, but when looking at the now related ( bi directional) debit adjustment in the AP Invoice document, I do not know where to find the relation back to the RC. Am I missing something?

Hello everyone,How to effectively map meta fields of BigCommerce order in the Entities mapping of BigCommerce connector under Formula editor?This doesn’t work. (order is the namespace and orderType is the key) 

We have template items setup with matrix items that map to the BigCommerce variants. Client does not want price or weight to populate BigCommerce from Acumatica. They want to maintain that in BigCommerce only. I’ve set in both the Stock Item and Template Item entity to unmap these fields yet the variant in BigCommerce is updating the price/weight based on what is on the variant in Acumatica. Is there a better way to accomplish this? This is 22 R1 for reference. 

I have an import scenario that will create sales orders from files added to an FTP server. I can set up an automation schedule to run the import scenario (we need it to import multiple times a day), however it is unpredictable when new order files will be added to the FTP site and I don’t want the import scenario to run if a new file hasn’t been synchronized, otherwise it will create duplicate sales orders in Acumatica.Anyone have any direction on the best way to go about this?

I want to override the sold since radio button in “Inventory Lookup” panel on Sales Order screen, so that, it will display non stock items. 

Hi all,Sorry if this question has been asked before, but I couldn’t find any related topics so if it does exist, please can someone point me to that :) I have a question related to the implementation best practice for customers who have existing stores. From what I can see, both BigCommerce and Shopify only support “Export” operation from ERP > Store. Let’s say in their stores, they already have a number of products. These products are exported to excel, provided to the implementer to import into Acumatica using an import scenario. Then, we set up a sync to export these products again to the stores:Wouldn’t this duplicate their product list? In relation to the above question, if it doesn’t, how does the system know a product in ERP is the same product in the store? Similarly, for customers, how to link an existing customer record in the ERP with an existing customer record in the store? this can be important to some businesses if they want to reserve the past/historical orders infor

Hey folks,I have a Shopify order which had Item A.   Item A does not exist in Acumatica and we tried to sync the order and it failed as expected. We changed the item to Item B which does exist, and removed item A from the order and restocked in shopify.  The order still refuses to sync in ACU claiming that ITEM A does not exist in ACU: The XXXXXX item in the XXXX store does not match any item's inventory ID or alternate ID in the ERP system. Make sure an item with "XXXXXX" as an inventory ID or alternate ID exists in the ERP system, and process the record again.It appears to still be in The JSON file as well...any thoughts here?

I would like to discuss the details of syncing template items’ options with Shopify in this post.First, some background.ShopifyIn Shopify, we have products with variants. If a product has variants, it is done through options. For example, you can have Color as an option, and that option can have different values: Red, Blue, White. At the same time, a product can have another option - let’s say, Size, with values 2, 3, 4, 5, 6.AcumaticaIn Acumatica, we have Template Items with Matrix Inventory. Matrix Inventory (matrix items) are variants of the Template Item. The way they are connected is through Attributes. Attributes are first created on screen CS205000. The type of this attribute should be Combo. Then the attribute is added an Item Class with the type of Variant, and then we can generate matrix inventory on the Template Items screen or connect existing items to an existing template item, by filling out attribute values.ChallengeFor online stores, it is sometimes important to assign