Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1462 Distribution 1420 Manufacturing492 Construction464 CRM98 Field Service220 Retail-Commerce367 Payroll177 Low Code | No Code Customizations or Integrations151 Develop Customizations2095 Develop Integrations with Web Services | APIs458 Other Developer Topics120 ISV Solutions 109 Configuration and Installation 636 Reports and Generic Inquires 1415 Import and Export Scenarios 540 System Health and Performance 115 Community site discussions183 Community Introductions88 Everything Else 622
News & AnnouncementsAcumatica News & Updates97 Events & Meet-ups127 Developer Newsletter 19 Newsletter 37

Create topic
Login

Community
Discussion Forums
Retail-Commerce

Retail-Commerce

Commerce Edition QnA

367 Topics
1,528 Replies

When you subscribe we will email you when there is a new topic in this category

367 Topics

Most replies

Recently active Most views Newest first

geoffreymFreshman II

asked in Retail-Commerce

Payments not syncing from BigCommerce for manual orders (back end of BigCommerce)

Hi,We are using the BigCommerce connector with acumatica 2021 R2, but have noticed that payments do not sync from BigCommerce if the order type in BigCommerce is “Manual Order”. These are orders that are taken manually by staff using the backend of BigCommerce. They use exactly the same payment method. In fact, I have compared the GET results of the “payment” endpoint for a normal website order, and a manual order, and the payment REST response looks identical from BigCommerce. So is the acumatica connector programmed to NOT sync these payments? If I try to manually sync the payment (Sync History->Add New->specify the external order ID) then it says “the payment record cannot be syncronized because it does not exist in the external system) Hoping someone has some insight, as I can’t find any information in the documentation as to why these payments can’t be found by acumatica. ThanksGeoff

1 year ago

HarshitaCaptain II

asked in Retail-Commerce

How can we find the Administrator box (Store Administrator Details) in the BigCommerce Stores(BC201000) form?

As per the V200 Manual:

1 year ago

mikehoSemi-Pro I

asked in Retail-Commerce

Order types for export to Shopify

We recently upgraded to 23R1 and are interested in turning on the Order Types for Export feature under Shopify Stores > Order Settings in Acumatica. However, we’re trying to get a better understanding of what will happen once we select the order types that we want to export to Shopify.Does anyone know if the connector will sync all historical orders of those types? Or will it sync only new orders from that point on? Is there a way to control which orders are synced?

2 months ago

ppowellVarsity III

asked in Retail-Commerce

How do we sync Sales Prices applied from Sales Price Worksheets to BigCommerce?

I have been asked to enable updates from Acumatica to BC when Sales Prices are updated using Sales Price Worksheets. We have several customer price classes in Acumatica (RET, WHL, 1STWHL, GUEST and Base). Any changes to prices for items made that day are updated every evening with a price class worksheet for each of these Price Classes.We want these updates to propagate to the sales price in BC automatically.In BC we have Price Lists for:WHLRETGUEST (inactive currently)and Customer Groups for : 1STWHL, WHL, RET, GUEST Is this something that is built into the BigCommerce Connector? I am a bit confused. I opened the Entities screen and see a Price List option.Do I simply make this active and then do a manual sync? I also see in the Push Notifications that there is BC-PUSH-Prices. If I open BC-PUSH-Prices and check the conditions it seems to be linked to AR-SalesPrice which is what I believe the Sales Price Worksheets update and in the conditions looking for Entity Type PR but if I ch

1 year ago

guslJr Varsity III

asked in Retail-Commerce

Digital Item: Acumatica to Shipstation -

Hey everyone, we have a client that’s trying to sync orders from Shopify to Acumatica but they’re shipping orders through Shipstation. Unfortunately, Shipstation is picking up these digital items as physical items from Acumatica but not from Shopify? Is there some sort of work around? Given the fact that we cannot alter shipstation’s mapping, is there anything else we can do?

5 months ago

bernadeth58Jr Varsity III

asked in Retail-Commerce

Unique SKU description

Hi everyone. Is there a way to sync SKUs with the same descriptions from Acumatica to the Bigcommerce?

1 year ago

PreethinFreshman I

asked in Retail-Commerce

Confirm Shipment API call

I am trying to figure out a way to update Fulfillment status and Confirm a shipment in one call instead of doing 2 separate calls, to get this approach working would it be difficult to extend the web service endpoints?Do y’all have any better option or the best way to go is make multiple calls?

8 months ago

jib87Jr Varsity II

asked in Retail-Commerce

Updating Every Matrix Item Description thru Template Item Description

Hello everyone,I create matrix items from a Template Item, with description segment settings uses the Template Item Description together with Attribute value.After creating matrix items, I updated the Template Item Description, hoping that it will auto updates every matrix item description inheriting the changes I made in the Template Item. But it does not.Clicking the Update Matrix Items button doesn’t work also.Is there a way to update the matrix items description from the template description changes without updating each of them?Appreciate your help. :)

2 months ago

jjakabcsin37Freshman I

asked in Retail-Commerce

BigComm order is synced into 2022R2 cleanly. But then it is switching back to "Prepared" Status in Sync History

We just upgraded to 2022R2 - Build 22.207.0013.And we are having performance issues with our order syncs from BigCommerce. The orders are Preparing and Processing as expected - and this is verified in the Sync History page.However - shortly after processing into the system, the order gets switched back to a status of “Prepared”. The system is then trying to re-process the same order - even though it already exists now.This is causing system perf issues as the day goes on - and the number of orders grows. The Prepare and Process jobs are scheduled to run every 60 seconds.Thoughts?

7 months ago

harshita53Jr Varsity I

asked in Retail-Commerce

Merchandise Planning

Hello Community,I was wondering if Acumatica supported Merchandise Planning. If yes, please guide me through steps. Else how can we achieve this in our Acumatica system.Thanks in advance.

4 months ago

davidgFreshman II

asked in Retail-Commerce

Shopify to Acumatica 2

Synchronizing Payment from Shopify to Acumatica, I got this:“The payment could not be imported because the SO064037 sales order has been fully invoiced. Create the payment manually on the Payments and Applications (AR302000) form and apply it to the invoice.”Yes I agree, we receive this order 2 days ago, and we shipped it and invoiced. customer paid it today. Why Acumatica cannot create Payment? What setting I have to check?

7 months ago

mikehoSemi-Pro I

asked in Retail-Commerce

Merge Sales Category export as Product tags in Shopify

If I set this inventory setting thusly under Shopify Stores in Acumatica: Acumatica will sync the Sales Category to Shopify as a product tag, which is great.However, if you add any additional tags in Shopify, the Acumatica connector will REPLACE them all with the Sales Category tag every time a sync occurs. Which is not so great.Anyone know if it is possible to make the Sales Category tag MERGE with any already existing tags in Shopify instead of replacing them all?

3 months ago

aaldrichFreshman II

asked in Retail-Commerce

How to get sales price from API - customer specific including fallback

HI,I’m wondering how I can use the Acumatica Apis to retrieve the price for an item based on the inventoryID and the CustomerIDI’ve found the /entity/Default/20.200.001/SalesPricesInquiry API - I can use this to get the base price and the customer specific price.From what I understand in the Acumatica ERP there is a hierarchy for the price as follows Customer SpecificCustomer Price Classand then finally Base priceSo it appears that I could figure out the price for an item by making an inquiry for each of those steps and using the first one that returns a price?I feel that this is not a great solution though because this is getting into the details of the business logic of Acumatica. Is there a way to send the information for the Customer and Inventory ID to the API and just get the price?

10 months ago

PhilJr Varsity III

asked in Retail-Commerce

2021R2 Product Availability Sync Issue - IdentifyNoteID parameter out of range?

Upgraded to 2021R2 and running through full resync of relevant entities - Sales Category → Stock Item → Non Stock Item → Template Item. Got to Product Availability, and encountered a new error I’ve not previously seen: Error: Specified argument was out of the range of valid values.Parameter name: IdentifyNoteIDSteps: Ran a ‘Full’ Prepare request for Product Availability Entity (previous automation schedules inactive since just prior to cutover to new release). Attempt to Process records. Encountered error above. The records do not appear to fail (ie, do not move to a failed or aborted status in Sync History), but just remain in the ready to process queue. I’ve approached this from both the prepare/process screens and from the sync history screen, and keep encountering the same error. Acumatica Trace from this screen:Right now I don’t have a means to reconcile product availability since our cutover 72 hours ago, which is problematic.

1 year ago

bzelinskiVarsity I

asked in Retail-Commerce

Show Sales Price

Does anyone know how to have the sales price from the “Sales Prices” show up as a column on the Inventory Items query?I have been able to do it, but it duplicates the inventory items many times. Here is how I built the relationships: What am I missing?

11 months ago

lawsontFreshman I

asked in Retail-Commerce

Create Auto-Incremented 6-digit Code for each Stock Item Upon Creation - Business Event?

Hi, we’re onboarding Acumatica now and would like to confirm this is possible. That is, can we use a Business Event or other functionality in Acumatica to automatically create a 6-digit Alternate ID upon creation of a Stock Item that would serve as a barcode? We would need to it to auto-increment so that it’s unique.

4 months ago

dcobeyFreshman I

asked in Retail-Commerce

Complex Pricing through Acumatica

Hi Acumatica Forum - First - I’ll call out that I’m new here. If I am posting in the wrong place (or posting something obvious), please let me know. Now, getting to business. I’m trying to use acumatica to do some pricing calculations and updates automatically. I’m finding it to be quite limiting. I’m curious how other retail locations use acumatica and how they update prices. Specific things I’m trying to do: Rounding - I’m trying to implement basic rounding rules (i.e., all prices need to end in $X.99) Pricing Overrides - setting up prices that aren’t automatically repriced Pricing Experiments - setting up a control and treatment group (at the item level) to see how much customers respond to select price decreases (by shifting purchasing). Pricing alarms - for example, sending an email if we sell an item below cost. At this point, we’re doing pricing through downloaded spreadsheets. But there is no way that will be sustainable in the long-term. Thanks!David

2 months ago

K2aJr Varsity III

asked in Retail-Commerce

Shopify Tag import via Commerce COnnector

Sorry if this is a duplicate post, but I couldn’t seem to find the right answer…Hello,Looking to see if anyone knows how to reference Shopify Tags on the Commerce Connector.The screen in Sales Orders has space for shopify tags: In my Sales Order Entity (commerce connector) I want to pull in the TAGS from the SHopify order, but I don't know the SHOPIFY syntax for doing so, assuming it’s the [Keyword]:[NameSpace] or [Value] setting:Any help is appreciated!K2

1 year ago

rodrigocid34Varsity I

asked in Retail-Commerce

BigCommerce Channel Manager feature is supported in Acumatica connector?

Hi,Does Acumatica BigCommerce connector supports Channel Manager?Currently, our customer has two channels in BigCommerce Its my understanding that this feature gives BigCommerce administratros to have 2 storefronts with the same store. Does the Connector has the possibility to separate which products will be exported and used in specific frontstore?Or the products should be configurated in a new BigCommerce store to use a new store in Acumatica connector? Thanks!

2 months ago

bernadeth58Jr Varsity III

asked in Retail-Commerce

Double charging the Customer

Hi everyone.We encountered this issue. In the Bigcommerce, If a Customer uses a Credit Card during the checkout process, we have to Override their "Default Payment" method on the sales order. It needs to be overwritten with "AUTH NET." I just conducted a test transaction. The Customer in question has a default payment method of "ACH." But, during the checkout process I used a Credit Card. When the order synced to Acumatica, the Sales Order pulled the default payment method of "ACH." This issue gets even worse when a Customer has a Default Payment Method of "CREDITCARD" in our system. In that scenario a Customer could pay with a credit card during Checkout and then Acumatica will run their card again when the order is invoiced. Double charging the Customer.

1 year ago

VBrundageFreshman II

asked in Retail-Commerce

Shopfy Tax Mapping on Returns

We are new to the platform. We are experiencing difficulties when trying to sync returns from Shopify. We are getting the error message: The following tax identifiers from the external system could not be matched: PA STATE TAX. The ERP has failed to save the tax ID or the tax amount differs from the one that has been expected. Make sure that taxes are configured for the tax zone and tax categories. Also, make sure that taxes either have the same identifiers in the ERP and external system or are mapped on the Substitution Lists (SM206026) form. Has anyone experienced this issue and how do we correct the issue? We are currently manually entering all returns into Acumatica at this point. We do not experience this problem with a normal order or with a POS return.

8 months ago

CetyliteFreshman II

asked in Retail-Commerce

Deleting Ship-To locations

We need to delete some ship-to locations that are attached to a specific customer but I keep getting told that I don’t have permission to delete them. What do I do?

1 year ago

jib87Jr Varsity II

asked in Retail-Commerce

Is there a way to make Stock Items "Export to External" field as false?

We are integrating Acumatica and BigCommerce. There are >100k of Stock item records in Acumatica. With that amount, only a subset of products will be exported in BigCommerce based on criteria provided. We noticed that as a default, Export to External is set to true. Is there a straightforward way to achieve our goal where in only the identified items based on criteria shall be exported and the rest will not?Now, what we are doing is to create a GI and make everything Export to External as false, then running an Import Scenario to explicitly set the Export to External true based on criteria given.Hoping to hear your suggestions for a more direct and elegant way on fixing this. Thank you so much :)

3 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Greater flexibilty for updating prices in Commerce

A client has two web stores being synced to the same Acumatica tenant. One store, B2B only, will only use customer group pricing (AR Sales Prices by Customer Price Class) with a fallback to Default price and the other will use the Default pricing with occasional specials. The default price in a Big Commerce store can only be updated from the stock item or template item. The client wishes to update the default price on the B2Cstore using AR Sales Prices because the price may be different from the stock item default price for the B2B customers. Unfortunately the Base Price and Price List entities do not allow Export Mapping.Has anyone had this issue and how do they resolve it? Is it even possible to customize the sync process?

1 year ago

bernadeth58Jr Varsity III

asked in Retail-Commerce

Sales Order filtering by Branch

We currently have 11 Branches set up in our Acumatica but we wanted to export those sales orders created in Acumatica that is under one particular branch only to Bigcommerce. So, we created export filtering, see reference below. I tried creating sales order but seems to filter all orders instead of letting only SLC-APPL orders through.Is this supported by the native connection of Acumatica-Bigcommerce? Or any suggestion on how we can possibly do it?Thank you.

11 months ago

Page 5 / 15

Badge winners

freboredohas earned the badge Easy talker
khalmehcgchas earned the badge Easy talker
jvarughese23has earned the badge Easy talker
KELhas earned the badge Easy talker
marina25has earned the badge Financials expert

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage