Retail-Commerce

Commerce Edition QnA

  • 267 Topics
  • 1,010 Replies

267 Topics

smarenich
Acumatica Moderator
smarenichAcumatica Commerce Edition Team Lead
posted in Retail-Commerce

Requests and API calls Logging in the Commerce Connector

Hi All, Acumatica BigCommerce and Shopify connectors (as well as others connectors build on the Commerce frameworks) have ability to collect verbose diagnostic logs. By default, the logging functionality is switched off to keep performance up, but on the development instances it can be enabled. You have 2 ways - logs in files and request profiler. File LoggingLogging is based on the Serilog, so it has to be enabled vin the web.config file with the following appSettings instructions.<appSettings>.............. <add key="serilog:minimum-level" value="Verbose" /> <add key="serilog:using:File" value="Serilog.Sinks.File" /> <add key="serilog:write-to:File.path" value="[ACUMATICA SITE PATH]\Site\App_Data\main-.clef" /> <add key="serilog:write-to:File.rollingInterval" value="Day"/> <add key="serilog:write-to:File.formatter" value="Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact" /> <add key="serilog:write-to:File.shared" value

0
smarenich
Acumatica Moderator
1 year ago
josh.fischer
Acumatica Moderator
josh.fischerAcumatica Product Manager
posted in Retail-Commerce

Commerce Marketplace Integrations

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 

8
S
Varsity I
1 year ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

BigCommerce 20R2 - Release Payments checkbox is disabled

Hello Everyone,I have an instance with Build 20.212.0038 and have configured Authorize.Net as processing center and payment method and using to map with BigCommerce Authorize.Net payment method.But as soon as I am selecting Processing Center ID the Release Payments checkbox getting disabled and then the synced payment records are not getting released automatically.Can someone please suggest on how we can configure the settings to Release, synced payments automatically.  

4
vivekm
Varsity I
1 year ago
brothe58
Freshman I
brothe58Freshman I
asked in Retail-Commerce

Processing credit cards using REST API in 2021

I'm working to upgrade from 2019R1 to 2021R2.Credit card processing is quite different in 21R2 than I'm familiar with. I need some direction for how to process Sales Orders with Credit Cards using the REST API in 21R2.I'm currently using the REST API to insert Sales Orders with a credit card payment (authorized only, not captured) using the SalesOrder endpoint. As part of the API call to the SalesOrder endpoint, I only have to provide the PaymentMethod and external PreAuthorizationNbr. This corresponds to a tab in the SO called "Payment Settings". It works great, but no longer exists in 21R2. I understand that I now need to use the Sales Order -> Payments tab, but it's not clear to me how to associate the external pre-authorization with the Payment and Application using the REST API.Can anyone point me to documentation or examples or using the REST API to insert Sales Orders with pre-authorized (or even captured) credit card transactions.Should I use the REST API to build a Payment

2
brothe58
Freshman I
1 year ago
JohnCovati35
Acumatica Moderator
JohnCovati35Acumatica Moderator
posted in Retail-Commerce

IIGPOS 2021R1 build 105 has been released to the Community Page

We have released the latest AcuPOS powered by IIG for 2021R1 and 2021R1 IIGPOS User Guide.The latest AcuPOS by IIG build is 105 and User Guide works with the latest Acumatica ERP 2021 R1 build 116. This information can be found Community >Product Downloads > Add-ons and Integrations > Acumatica Point of Sale (POS) powered by IIG

0
JohnCovati35
Acumatica Moderator
1 year ago
S
Freshman I
sburgerFreshman I
asked in Retail-Commerce

Is it possible to add two vendors to a stock item using the import scenario?

Is it possible to add two vendors to a stock item using the import scenario?

3
S
Freshman I
1 year ago
S
Freshman I
sburgerFreshman I
asked in Retail-Commerce

How do I add a barcode using the import scenario

Hi, How do I add a barcode to a stock item using the import scenario?

1
V
Acumatica Employee
1 year ago
S
Freshman I
sburgerFreshman I
asked in Retail-Commerce

Populate attributes thru import scenario

In our system, the item class creates attributes, how can I populate the attributes fields through an import scenario?

1
Naveen Boga
Captain II
1 year ago
M
Freshman I
mrivera67Freshman I
asked in Retail-Commerce

Dashboard to show the conversion Ratio of Quotes to SO

Hello Everyone, Is there a dashboard that will show the conversion ratio of quotes to Sales Orders? If not, what is the possible workaround? Thank you! Kind regards,mrivera67

1
smarenich
Acumatica Moderator
1 year ago
K
Freshman I
kjasinskinescFreshman I
posted in Retail-Commerce

Acumatica Retail Commerce Edition and Amazon Sellers Center (fulfilment by merchant)

Hello, I heard that Acumatica have plans to implement native features, which allow to connect Acumatica with Amazon marketplace. Do anyone have some more information about this?I heard also that, there are something like “Acumatica Retail Commerce Edition” and on 2021 R2 it will be connected with Amazon marketplace. The main questions for me is that it’s only for Amazon Marketplace (fulfillment by Amazon) or Amazon Sellers Center  (fulfillment by Merchant). Thanks fro all replies

2
K
Freshman I
1 year ago
L
Freshman I
LukeSepeFreshman I
asked in Retail-Commerce

Default One Time Use Password for Commerce Integration

When creating a new Customer in Acumatica and pushing the entity over to an eCommerce website there is currently no way to directly define the password from within Acumatica by default. If a one time use password is desired it must be configured manually by an administrative or clerical user within the eCommerce platform ( Shopify / BigCommerce / etc ). The only alternative for the first login is to direct the customer (who’s new account has no password) to go through the password reset process which is cumbersome and takes multiple steps. It would be a far better user experience for the customer to instead be given a one time use “throw-away” password in Acumatica that is known in advance and then force to the user to reset after correctly authenticating for the first time similar to the process that exists within Acumatica. The only requirement here would be for Acumatica to add the password fields from the eCommerce API to the field mapping since the API on the eCommerce side alread

2
josh.fischer
Acumatica Moderator
1 year ago
M
Freshman I
mkideckelFreshman I
posted in Retail-Commerce

Shipstation vs ShipEngine vs EasyPost

Hi,I’m looking for a shipping carrier integration with Acumatica and was wondering what the best options are of shipstation, shipengine and easypost? Thanks,Mitchell

7
D
Jr Varsity III
1 year ago
mbrown30
Jr Varsity II
mbrown30Jr Varsity II
asked in Retail-Commerce

BigCommerce Product Image - populate "Description (Image alt text)" during image upload from Acumatica.

Hello  Is it possible to populate the Description (Image alt text) field in BigCommerce when uploading images from Acumatica using the Acumatica connector.  Thanks  Matt

2
mbrown30
Jr Varsity II
1 year ago
M
Freshman I
mkideckelFreshman I
asked in Retail-Commerce

Generic Inquiry - edit fields on screen

Hi There,Is it possible to make it so you can edit fields directly on the generic inquiry screen?For example, I created Attributes for amazon prices and asins, and it would be convenient to be able to edit them on one screen / on the fly for all the products instead of having to go into each item or doing a data import. Would like to create something like the sales prices screen where you can edit all the prices in one spot.  Thanks in advance for the help. 

2
D
Varsity I
1 year ago
sergueiploujnikov94
Freshman III
sergueiploujnikov94Freshman III
posted in Retail-Commerce

An ability to Re-Sync the Invalid record.

In Acumatica ERP 2021 R1 Update 16, the records that have got the status “Invalid” in Sync History  (BC301000)  form after the first synchronization attempt are not available for the immediate Re-Sync.Fig.#1. The checkboxes on the lef are not clickable for the record with the status “Invalid” on 2021 R1 Update 16.The user will have to:Delete the Invalid record; Remove the issue which has led to mark the record as Invalid; Run again the Prepare process; Then, Process or Re-Sync the record in question.This behavior recognised as cumbersome and ineffective.That is why it has been corrected in version 2021 R1 Update 17, which is scheduled for the release on 3 of December, 2021.Starting from this version the unnamed checkboxes  in the table of the Sync History (BC301000) form for the invalid records become clickable and thus accessible for the Re-Sync.Now, if the user tries to sync the Invalid records the system re-validates to make sure that the record is valid is sync. If all is good then

0
sergueiploujnikov94
Freshman III
1 year ago
sergueiploujnikov94
Freshman III
sergueiploujnikov94Freshman III
posted in Retail-Commerce

Default Automation Schedules.

Clients are having hard time automating the synchronization processes between e-stores and ERP. Such as syncing entities like Orders, Payments, Refunds and so on.So, we decided to prepare and provide the pre-configured Automation Schedules which Customer can activate and use at his/her convenience starting from 2021R2 version.You will be able to find them at the Automation Schedules form (SM205020).They come in two portions:One is for preparing data:Prepare Sales Order; Prepare Shipment; Prepare Refund; Prepare Product Availability; Prepare Stock, Non-Stock, Template Items.With the following default Schedules: Entity Schedule Frequency Sales Order Every 10 min. Shipment Every 30 min. Refund Every 20 minutes. Product Availability Every 1 hour. Stock Item Every 24 hours. Non-Stock Item Every 24 hours. Template Item Every 24 hours.  You can also find them at Prepare Data

2
C
Varsity II
1 year ago
sergueiploujnikov94
Freshman III
sergueiploujnikov94Freshman III
posted in Retail-Commerce

Limitation of the Real-Time Sync for the Certain Entities.

The Real-Time Import and Export Features on the Entities screen (BC202000) will be disabled for Customers, Customer Location, Sales Category and Customer Price Classes in version 2022R1 of Acumatica ERP.The reason behind this decision is performance issues of the SAAS system. The use of the Real-Time sync with the large amount of customers accounts requires a lot of system resources, which may affect the Connector performance.But fear not!First, for the customers which already use the Real-Time synchronization, we have prepared the customization project which enables this feature back. You may find the customization package file attached to this article, it will work with 2022R1 version.And secondly, we have more effective feature as an alternative solution. It’s the Default Automation Schedules. They are more stable and more effective feature than the Real-Time Sync.

0
sergueiploujnikov94
Freshman III
1 year ago
D
Jr Varsity III
dougmcbride79Jr Varsity III
asked in Retail-Commerce

Sync Credit Hold from Acumatica to Big Commerce

We have set up automatic credit hold in Acumatica.  Can this credit hold be synced to Big Commerce, so if a customer on credit hold tries to place an order on Big Commerce, the customer is told in Big Commerce the customer is on credit hold and prohibited from placing a Big Commerce order? 

1
josh.fischer
Acumatica Moderator
1 year ago
eleanorp
Freshman II
eleanorpFreshman II
asked in Retail-Commerce

Errors for BigCommerce Connector

Hello, I am seeing two errors when I sync entities between Acumaitca and BigCommerce, and was wondering if anyone had any ideas. The errors are:Input string was not in a correct format. → Only on stock items. The last operation is Failed to Save Externally, and they are not synced to BC.Could not find a part of the path 'c:\windows\system32\inetsrv\[username]\users\[BC customer ID #]\companies'. → Only on customers. The last operation is Inserted Externally, and they are synced to BC. I can’t see the difference between the records that are synced and those that are not. I appreciate any help I’m able to get!   

1
smarenich
Acumatica Moderator
1 year ago
apretorius62
Freshman I
apretorius62Freshman I
asked in Retail-Commerce

big commerce payment terms for customers (B2B)

HII want to do the following with BC.One can setup various payment methods. Some offline, some online. I only have offline.when a customer have enough credit then I don’t want them to see credit card payment method in BC, only must have method, “on credit”when they don’t have enough credit, I want them to see Credit card payment method and not see “on credit” payment method.Any ideas?

3
KarthikGajendran
Acumatica Moderator
1 year ago
smarenich
Acumatica Moderator
smarenichAcumatica Commerce Edition Team Lead
posted in Retail-Commerce

How-TO: Import Sales Order Lines custom field with Commerce Connector

Acumatica Commerce Connector does not allow mapping of the custom fields for the Sales Order Lines using Entity mapping screen, however, you can use customization engine and include custom fields.To do so, you can create an extension for the Sales Order Processor and include the SO Line custom fields in the API Object.//BCSalesOrderProcessor is the main class that does synchronization of the Sales Orderspublic class BCSalesOrderProcessorExt : PXGraphExtension<BCSalesOrderProcessor>{ public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing); //MapBucketImport is mapping the eCommerce API object to Acumatica API Object. [PXOverride] public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod) { baseMethod(bucket, existing); foreach (var detrow in (IEnumerable<SalesOrderDetail>)bucket.Order.Local.Details) { detrow.Custom = new CustomField[]

1
F
Freshman I
1 year ago
jgress
Jr Varsity II
jgressJr Varsity II
posted in Retail-Commerce

eCommerce Bundled Items or Assembled to Order

We have customers and prospects with a requirement to assemble products based on a customers request, either through a ecommerce store or through direct input into Acumatica.  Some examples of these scenarios are below: Variety Packs Pick any 6 of our flavors or frangrences to make your own pack.  Using matrix items is not a viable solution given that these customers may have 300+ individual items. Made to Orders based on variables. Manufacturing is overkill and does not interface with ecommerce connector. Needs to be rules driven to avoid misconfigured items. Is this an indoor or outdoor applications? Do you want still images or video? What megapixel level? (doesn ot allow megapixel levels not compatible with video if selected) What country? Which cellular provider? (does not allow a provider which is not available in selected country) Issues: How to faciliate the order in the ecommerce store so that it passed to Acumatica correctly? How to faciliate the order for

20
josh.fischer
Acumatica Moderator
1 year ago
M
Jr Varsity II
mpowellJr Varsity II
asked in Retail-Commerce

Government Interfacing with the Customer Portal

Has anyone had an experience with a government agency utilizing the customer portal to place orders? We produce and sell medical equipment to the military and are looking to simplify the ordering process but with the government’s security level we aren’t sure if they will be able to use the customer portal. Any advice? Thanks!

1
josh.fischer
Acumatica Moderator
1 year ago
M
Jr Varsity II
MichaelTobiJr Varsity II
asked in Retail-Commerce

Mapping Shipping Method in BigCommerce to Ship Via in Acumatica

Do we have the ability to offer different Shipping Methods in BigCommerce that will be mapped to existing Ship Vias in Acumatica? Would this configuration through the Entities work well?Where do we map the Shipping Method in BigCommerce to the Ship Via in Acumatica? 

3
KarthikGajendran
Acumatica Moderator
1 year ago
Mike Gifford
Freshman I
Mike GiffordFreshman I
asked in Retail-Commerce

Can you map Acumatica Customer ID to BC Customer user field

Our implementation is such that all customers will be generated in Acumatica and pushed to BC prior to the customer logging into the BC storefront. Is it possible to push the CustomerID to BC into a customer user field? I looked into the articleHowever, it doesnt seem to allow CustomerID to be a source - nor does it seem to allow custom fields on the BC Customer object.We have some supplemental API inquiries that BC is going to do which require the CustomerID and it would be best if it were already there. Relying on the email address as a unique key when it isnt required to be unique in Acumatica doesnt seem like the right way to go.Any thoughts?

7
M
Jr Varsity II
1 year ago

Badge winners

  • Reports and Generic Inquires expert
    aborisova37has earned the badge Reports and Generic Inquires expert
  • Configuration and installation expert
    aaghaeihas earned the badge Configuration and installation expert
  • Acumatica Expert
    Yuriy Zaletskyyhas earned the badge Acumatica Expert
  • Acumatica Expert
    meganfriesen37has earned the badge Acumatica Expert
  • Customizations expert
    ray20has earned the badge Customizations expert
Show all badges
Terms & ConditionsCookie settings
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.
© 2008 — 2022  Acumatica, Inc. All rights reserved