Retail

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

Hello everyone,How to fix the above error? This is an order placed in BigCommerce from a B2B customer. Also, to add context: the user used to placed the order is a super admin, that “masquerades” the Customer, and place order in behalf. Not sure if that is related, but just mention if can help.

I am new to shoplifty I am trying to help customer map new fields from the Shipment to Shopify Is this done on Entities as below ? 

Trying to sync Sales Orders coming from Shopify and it has that error.I also tried for Customers created from Shopify. 

Hey Everyone, I have a unique situation I’ve never come across before. I have a client using the Shopify connector. In their Shopify store they sell the same product with the same SKU as a stand alone product as well as selling it as a part of up to 4 matrixed items. Acumatica only allows us to assign 1 Template item per product, however I need the ability to assign multiple template items to 1 stock item. Ideally I would also need the ability to sync the individual stock item by itself.The primary reason we need the ability to do this is to allow us to sync product availability to the stand alone product in shopify as well as the sock item that is a part of the template items in order for Shopify to have correct product availability for all the iterations that this 1 stock item is sold as in Shopify.I’m hoping someone else may have come across this and might have a workaround or solution. I created a case with Acumatica and they suggested a customization might be the only solution. An

Hi Acumatica folks,I just want to ask if anybody noticed too the order Description in Acumatica that is created from BigCommerce and synced to Acumatica.As shown in the screenshot, the Description contains the name of the store, the BigCommerce Order ID, and the status of the order in BigCommerce. Sometimes it say Awaiting Payment, sometimes it says Awaiting Fulfillment.Just wondering why despite orders being processed in Acumatica (created and confirmed shipment and creates and pay invoice), the status in the Description keeps saying Awaiting Fulfillment/Payment. Sometimes, it confuses us.Do you see that as a concern as well? If yes, what have you done to update the Description with the actual status? Or alternative way to avoid the confusion?Best regards 

Hello,We have two retail stores that are setup as two separate Branches in Acumatica - say Branch1 and Branch2. On Shopify POS each retail store is a separate Sales Channel - say Channel 1 and Channel 2. I have been unable to find a way to map or tell Acumatica that Shopify POS Sales from Channel 1 belong to Branch1 and Channel2 to Branch2. All Shopify POS Sales fall under the same Acumatica Branch. Is there a workaround or a setting I am missing? Thank You

Is there a process that allows us to create a shipment document out of a return to vendor? Once the “return to vendor” process has been completed, our warehouse needs the ability to physically ship the products back to the vendor. We are currently using the ShipEngine integration and therefore would need a Shipment document created so we can create the shipping labels for the return.

Our purchaser often receives new pricing for items and we would like to update the cost of goods before we place a purchase order. I understand that last cost of goods is updated upon the inventory receiving process, but how can we update costs without placing a purchase order?Most of our items are FIFO and I see that “Last Cost” is an editable field. Is that the best way to update costs?Thanks!

Hi Team,I am working with 23R2 (Build 23.209.0023) Shopify connector. I have a custom table and a custom screen. I want to create a new Entity similar to the Stock Item and sync the data from custom table to Shopify as stock items. I tried to create a new graph using SPProductProcessor but getting error while inheriting from this class. Then I used ProductProcessorBase, using which I am able to get the data in Sync History but during sync objects are getting null and further processes are failing.Can anyone suggest the best possible way to achieve it.Thank you in advance !

“New connection to support Shopify’s new payments platform is now available!We encourage you to act now by following these steps.You will need to make all changes by June 28, 2024, to prevent the payment card option at checkout from disappearing.”Shopify App: https://apps.shopify.com/authorize-netAnyone having issues with payment importation? (wrong processing center ID, no 10 digit trans key from auth.net) 

I’m doing the V200-Commerce Edition training.I’ve setup a trial for BigCommerce and have configured the setup as per the guide within the training.When I try to create a BigCommerce store I get the following error:“Index was outside the bounds of the array.”Has anyone come across this issue? Stack Trace:    at PX.Data.PXStringState.get_ValueLabelDic()   at PX.Data.PXView.SortResult(List`1 list, PXSearchColumn[] sorts, Boolean reverseOrder)   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows, String[] sortAsImplicitColumns)   at PX.Commerce.Core.BCBindingMaint.<entities>d__4.MoveNext()   at System.Linq.Enumerable.<OfTypeIterator>d__95`1.MoveNext()   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)   at _CustomMethod(Object , Objec

We are using Average Cost on our invoicing. However the issue with this is the service orders only show the costing from when they were created. This means the totals tab calculates the estimated profit and loss from this. Shouldn't this be calculated off the average cost or am I missing something ?

Hi, I have been doing a lot of tests and I realized that when I map the Branch field at Order Level, the value is not changed but when I do it at the detail level, it does:**the 2 lines within the mapping are just an example, I ran the tests with one of them only. Does anybody found the same issue and a solution?  Thanks!  

Hi there, We are using the Shopify Connector for the POS side of things. During our Testing, we synced an Order to Acumatica, then refunded it partially and another example for a full refund.We get the following Error: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.; COMMERCE]: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.;Connector: SPC, Binding: 2, Entity: OR, SyncID: 24455, LocalID: , ExternID:PX.Commerce.Shopify.API.GraphQL.GraphQLAggregateException: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.; Refunds are enabled and we have a Return Amount Item set-up. We are using the Shopify public App for Acumatica. Not sure where to start