Retail

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

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

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

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) 

 IssueI am unable to find a field in the ecommerce Sales Order export mapping that indicates that an order has been paid via check on a related invoice. BackgroundWe work with government agencies across the nation, allowing them to pay via Purchase Orders, where we invoice them at Net 30 terms.We have set up a manual payment method on Shopify called 'Purchase Orders.' This method is configured in our e-commerce store settings in Acumatica but is not active. If we activate this manual payment method, orders will be marked as 'Paid' on Shopify, which can mislead some customers into thinking they owe nothing. This also adds a prepayment to the order, causing Acumatica to show all invoices as paid, resulting in no invoices being sent to customers. Consequently, we do not receive payment.To pay these orders, most customers send in a check, which we then apply to invoices in Acumatica. This payment informat

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

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  

In this topic we will review how we can extend/workaround areas not supported by either Acumatica’s Shopify Connector or Fields not being passed by Shopify APIsIn the use case below. Customer wants to filter the orders that are “on hold” in Shopify. This status is currently not supported with the current connector but will be included in future releases once Acumatica switch to use the new “GraphQL”. For now the workaround was to use Shopify “Flow” to add a tag “ThisOrderIsOnHold” and filter on this tag in Acumatica. Following are the detailed steps1-Create a trigger in Shopify to add the tag “ThisOrderIsOnHold” when fulfillment status is “on hold” When user puts order on hold

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

I want to show you a way how can you configure saving of a Credit Card Profile inside Acumatica even if the payment is done on the BigCommerce side.This functionality is possible only if both of the systems have integration with the same Credit Card Processing Center. In my case I will use example of Authorize.NET as this processing center is supported and by Acumatica and by BigCommerce. Step 1: We should configure Authorize.NET plugin at BigCommerce (under Store Setup → Payments) to store credit cards:Please note that it will be up to user to store or not the credit card information with you. Step 2: Now if user places the order, there will be an option to save card for the future usage on the payment settings:

Hi, all orders coming from Shopify POS generate this error: “Object reference not set to an instance of an object.” What do you think I should check?

We are reviewing switching from Big Commerce to Shopify.  We are stuggling with cost effectively customizing our Big Commerce store.  Is Shopify B2B a good solution that can be customized cost effectively? 

The Custom Field in BigCommerce could be added using the Commerce Connector from the Entities form(BC202000). Imagine you would like to map a attribute or custom field or any field from Acumatica Stock Item form to a custom filed in BigCommerce product page and this custom field in BigCommerce is not yet created. Go to Entities form(BC202000), select Stock Item Entity.  Go to Export Mapping Tab Click plus (+) button In the Source Object, select the required Acumatica object. Eg: Attributes or Advanced  In the Source Field/Value, select the required Field.  In the Target Object, select the object as Product->Custom Fields. In the Target Value/Field, select <<Automapping>> as shown in the screenshot. Now when the stock item is exported next time, connector will automatically create the Custom Field in BigCommerce with the same name as in Acumatica. If the field alread