Retail-Commerce

Commerce Edition QnA

  • 371 Topics
  • 1,540 Replies

371 Topics

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
2 years 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
2 years 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
2 years ago
Mike Gifford
Jr Varsity III
Mike GiffordJr Varsity III
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
2 years ago
A
annanesterovaAcumatica Business Analyst
posted in Retail-Commerce

Card type (VISA, mastercard etc) for credit cards and transactionsd - how you would use it?

Hello, we think about adding information about card type such as visa, mastercard, AmEx etc for card payments and cards stored in the system and would like to make it as useful as possible.Please share your thoughts on how you could use this information. 

0
A
2 years ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

Shopify 21R1 - How to implement core connector Product Data Get/Update resources for new a Graph

Hello Everyone,I have a requirement mentioned as below:I have to create a new graph. Implement a button on this graph. On this button click have to Get/Update specific Product data with some additional details.I am trying to use core connector Product Data Get/Update resources for my new Graph, similar to SPStockItemProcessor graph but is not working. Please find below details that I have tried as a part of customization:Created graph - Please find attached ‘Test Graph Code’ document for reference. Created aspx page and defined button - Please find attached ‘aspx Code’ document for reference.Getting object reference error and on debug find out productDataProvider object getting null.public PXAction<KNSPPLMetaFieldsFilter> CreateStockItem;        [PXButton()]        [PXUIField(DisplayName = "Get Product Details")]        protected virtual IEnumerable createStockItem(PXAdapter adapter)        {            ProductData data = productDataProvider.GetByID("6618593099970"); // productDa

7
vivekm
Varsity I
2 years ago
NickB
Freshman I
NickB
asked in Retail-Commerce

BigCommerce: delayed credit card payment processing

Hello. Our customer wants to use the “verify & store” method when capturing the credit card orders in BigCommerce, which means they don’t charge the credit card until they are ready to ship the order. This could be a week later, or a month later if they need to order the stock.Does the 2021R1 BigCommerce connector support this scenario, and if yes, how to set it up?How can we “tell” BigCommerce to charge the credit card and take payment when we are ready to pick and pack the order in Acumatica?We have talked to BigCommerce, they say their API does support such delayed payment processing.Thanks!

4
NickB
Freshman I
2 years ago
M
Jr Varsity II
MichaelTobiJr Varsity II
asked in Retail-Commerce

How to map Acumatica attribute to Brand ID in BigCommerce?

In our BC implementation, we want to allow customers to shop by brand. Brand ID is a native field in BC. Is it possible to have an attribute in Acumatica that identifies the brand of a product which can then be sent over to BC? Here’s how we tried to have it set up but the sync does not seem to be working.  

1
KarthikGajendran
Acumatica Moderator
2 years ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

BigCommerce 21R1: To Put Acumatica Sales Order on Hold at the time of order Import, based on some conditions

Hello Everyone,I have one scenario where I want to put Sales Order on Hold at the time of order import from BigCommerce to Acumatica based on some conditions.I have implemented some logic in 19R2 build and that is working as expected there, as after checking required conditions, I used to set impl.Hold = true.ValueField(); please find below code sample for reference.public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing);        [PXOverride]        public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)        {            baseMethod(bucket, existing);            MappedOrder obj = bucket.Order;            OrderData data = obj.Extern;            SalesOrder impl = obj.Local;                        impl.Hold = true.ValueField(); // This implementation working fine in 19R2        } Now, coming to 21R1 we do not have Hold checkbox on Sales Order screen and instead we have Hold button to put th

4
vivekm
Varsity I
2 years ago
smarenich
Acumatica Moderator
smarenichAcumatica Commerce Edition Team Lead
posted in Retail-Commerce

Configure Acumatica-Shopify Connector to Save Customers with name as ShopifyID

Hi All, By default, Acumatica commerce edition require Auto-Numbering for Customers and Customer Locations. This is done due to a number of reasons:During the export customers from Acumatica, we don’t have a Shopify ID, so if customer is created in Acumatica it will have a different name. Acumatica can be connected to multiple stores and there is no guarantee that customer ID is unique accords multiple stores and connectors. Naming convention in Acumatica may be different from Shopify customer.In any case, Acumatica Commerce Edition will follow Auto-Numbering of customer and locations.However this can be changed with the simple customization.  Please do the following: Step 1: Extend the Segmented Key for BIZACCT and CUSTOMER to 13 or 14 characters. Customers ID in Shopify are very long. Step 2: Publish the attached customization . The customization package does 2 things: Disabling mandatory auto-numbering on customer record Assigning Acuamtica CustomerID to the Shopify ID. Step 3: Test

3
smarenich
Acumatica Moderator
2 years ago
R
Captain II
ray20Captain II
asked in Retail-Commerce

"level price" of item sync between Acumatica and Shopify

Hello,     Can anyone familiar with Acumatica and Shopify connector help confirm whether the below need is mission impossible at present.    We are using customer price class to set item price for different customers/customer classes. And since we are planning to use shopify to receive customer’s orders. Can these prices be sync up to shopify and displayed to customers?

1
KarthikGajendran
Acumatica Moderator
2 years ago
P
PeterNikolantonakis76
asked in Retail-Commerce

What happens when you check the box for "Automatically show related products in storefront" in the BigCommerce product page?

This action causes a problem where the related products disappear. In the BigCommerce product pages there is a checkbox which displays as "Automatically show related products in storefront".If the box is checked the window collapses and no longer displays the related products that were imported.Before CheckingIn the Store View the related products display below the main item.After CheckingOnce the box is checked, the Related Products window is minimized, and the related items are not visible anymore.Note that the page must be saved for changes to take effect.The Store view displays exactly as it did before.ProblemIn the case that the user wishes to uncheck the box, he/she must go back into the product page and uncheck it. However, this causes the related products to disappear.If the user saves the current state of the product when exiting, the related products disappear in the Store View as well.If the user does not save, the related products continue to display in the Store View as th

0
P
2 years ago
KarthikGajendran
Acumatica Moderator
KarthikGajendranAcumatica Moderator
posted in Retail-Commerce

Commerce Connector Customer Feedback

Hello Acumatica Commerce Connector users, There are many features released in every version of Commerce Connector. The product is growing bigger each day. That being said we would love to hear from you about features you like and about the areas where we need to invest more time to improve. We would greatly appreciate if you take few minutes to provide us this feedback. The feedback page has two sectionsShort answer questions - Require less than 2 mins to answer.  Long answer questions - Requires around 10 to 15 mins to complete. You could be generous and answer them or request for a meeting with product team who would be happy to schedule a call and discuss more.  Feedback Link: https://forms.office.com/r/XNzEnLm7d6If you have any questions about the feedback or ifthe link is not accessible, please feel free to contact Karthik Gajendran (karthik.gajendran@acumatica.com).

0
KarthikGajendran
Acumatica Moderator
2 years ago
C
Freshman I
cardfauxFreshman I
asked in Retail-Commerce

Some Stock Items Are Not Syncing Over

Some stock items do not sync over to BigCommerce, most of them do but for every 50-100 items that do sync over there is 4-5 items that do not. Most of the items, if I change the price, category, description it will re-sync itself and usually the ones that don’t I can force the re-sync and it will work. But occasionally a stock item won’t sync no matter what I change or how many times I resync everything, even if I force the re-sync it won’t pick up the changes on that specific stock item. I have set stock items the synced successfully and stock items that will not sync, side by side and both of them have the same settings. does anybody know what could be causing this issue? Thank You….

2
smarenich
Acumatica Moderator
2 years ago
dougmcbride79
Varsity I
dougmcbride79Varsity I
asked in Retail-Commerce

2021 R1: Orders will not sync to / from Big Commerce

Orders from our Big Commerce Sandbox will not sync down to our 2021 R1 Acumatica sandbox  Nor can we get orders in our Acumatica 2021 R1 Sandbox to sync up to our Big Commerce Sandbox.  We are on Build 2 of 2021 R1.  Is anyone else having these sync issues?  Does upgrading to the current Build 9 fix these issues?  We are stuck and our 90-day upgrade sandbox period is about to expire.  Any suggestions are greatly appreciated. 

9
smarenich
Acumatica Moderator
2 years ago
M
Freshman I
Magdad1Freshman I
asked in Retail-Commerce

Shopify - problem during payment import

Hello, Could you please help me with the following issue?When trying to import sales order and credit card payment from Shopify to Acumatica, I get the following error:  “Inserting 'Sales Order Adjust' record raised at least one error. Please review the errors.PrepaymentInvoiceRefNbr: 'PPI Nbr.' cannot be empty.”I follow the instructions from the training: V210 COMMERCE EDITION (SHOPIFY CONNECTOR) 2021 R1Have any of you already solved this problem or have an idea what it could be due to?Thank you in advance for any advice!  

1
KarthikGajendran
Acumatica Moderator
2 years ago
sergueiploujnikov94
Freshman III
sergueiploujnikov94Freshman III
posted in Retail-Commerce

Default Business Events for Aborted Synchronisation Notifications.

It might be extremely useful to get automated notification when some synchronization process has been aborted after a pre-defined amount of attempts. We have created several default business events that will automatically send the email notifications:Aborted Order. Aborted Refund. Aborted Shipment. Aborted Payment.These events will be available at version 2021R2.All of them are not active by default.To activate them open Business Events form (SM302050) and select one of these events (for ex., Aborted Order) and check the Active checkbox: That’s it! Next time when the synchronization of the entity (Sale Order in our example) will turn status to Aborted the automatic notification will be sent to the Store Admin email address which is set in the respective Stores forms BC201000, BC201010:  The notification could be found in All Emails (CO409070): When you click the respective link on the All Emails form, you may see how the email notification itself looks like: 

1
C
Semi-Pro I
2 years ago
S
Acumatica Moderator
StaceyReitz23
asked in Retail-Commerce

Acumatica Commerce Edition Overview (July 15, 2021)

Acumatica Commerce Edition Overview July 15, 202110:00 am - 10:30 am PSTRegister now.Join us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today! Register now 

0
S
Acumatica Moderator
2 years ago
brendan91
Semi-Pro III
brendan91Semi-Pro III
posted in Retail-Commerce

Shipping - Inaccurate prices (flat rate and regional)

Shipping seems to me to be an overlooked area of Acumatica, and I’m not sure why others have not come across this issue.In summary: We are getting inaccurate shop for rates prices when switching a package in the shipmentThis is our box setup, I will demonstrate using a USPS flat rate boxBOX017 = Small Flat Rate Box We add the package (box017) in the shipment and attach a weight of 2 lbswhen I shop for rates I get a return price of $7.79. The actual price for a small flat rate USPS box is $7.90In order to get the correct price to show up, I have to close the window and re-open the shipment.  If for whatever reason I want to change the box (ex. the large flat rate Box014) and the weight to 3 pounds, the shop for rates screen is frozen to the previous dimensions when I edit the package. Once again, I need to save the document, close the shipment, and re-open to get the correct pricing. Seems like this glitch makes us prone to inaccurate price quotes. 

2
mpawlowski95
Freshman I
2 years ago
dougmcbride79
Varsity I
dougmcbride79Varsity I
asked in Retail-Commerce

Acumatica and Big Commerce: More than one customer price class

We need customers to be in more than one Acumatica Customer Price Class for when we sync to Big Commerce.  We need one Customer Price Class for a 10% discount on Item Class A, and one Customer Price Class for a 15% discount on Item Class B.  Our issue is that when we sync to Big Commerce, we seem to be able to put a customer in only one Customer Price Class (called Customer Group in Big Commerce).  Does anyone know how to put a customer in two Customer Groups in Big Commerce?  

6
dougmcbride79
Varsity I
2 years ago
Phil
Jr Varsity III
PhilJr Varsity III
asked in Retail-Commerce

Best practices for variant/matrix updates (add/remove) between Acumatica and Bigcommerce?

As a long time user of BigCommerce and a relatively new adopter of Acumatica, curious if anyone has developed a best practice for handling changes to product variants and getting those changes to sync properly between Acumatica and BigCommerce.  Example: Product A initially set up with option for colors Green, Blue, and Red. Manufacturer drops Red and replaces with Yellow.  Thus far I have tried a) removing the depreciated SKU as a matrix item from the template item and adding the new matrix SKU to the template and syncing - error, b) same process but deleting the depreciated SKU from BigCommerce first - error, and c) same process but deleting all SKU variants from BigCommerce first - error. To resolve a time sensitive issue, I essentially deleted the item from BigCommerce and started over by pushing the template w/ associated matrix items back to the store and updating key fields from a prior export, which is not a viable maintenance strategy.  Any BC store owners have a good workflow

3
KarthikGajendran
Acumatica Moderator
2 years ago
paulinecho73
Freshman I
paulinecho73Freshman I
posted in Retail-Commerce

BigCommerce and Acumatica: A Unified Ecommerce & ERP Solution for B2C Companies - June 17

BigCommerce and Acumatica: A Unified Ecommerce & ERP Solution for B2C Companies  Thursday, June 17, 2021  10:00 AM Pacific Daylight Time  1 hourAs customer expectations rise around the entire shopping experience, the competition has also increased, making it difficult for organizations to get by with legacy commerce and ERP systems. The market has shifted tremendously, and B2C eCommerce has seen exponential growth over the past year, making legacy commerce and ERP systems inadequate to support the pace of modern business. Integrate your BigCommerce storefront with Acumatica’s ERP and elevate your customers' experience, gain greater insight into your business, and drive exponential revenue with a unified commerce platform from Acumatica and BigCommerce.Join Josh Fischer (Senior Manager, Product Management at Acumatica), Koy McDermott (Manager, Strategic Partnerships at BigCommerce), Dave Munson (CEO at Saddleback Leather) and Shawn Wyatt (Director of IT at Saddleback Leather) as the

3
S
Acumatica Moderator
2 years ago
S
Acumatica Moderator
StaceyReitz23
posted in Retail-Commerce

Acumatica Commerce Edition Overview Webinar (June 24, 2021)

Acumatica Commerce Edition Overview WebinarJune 24, 2021 10:00 am - 10:30 am PST Join us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today!Register now.  

0
S
Acumatica Moderator
2 years ago
vivekm
Varsity I
vivekmVarsity I
asked in Retail-Commerce

BigCommerce: To Sync Attribute Value Description Instead of Attribute Value ID

Hello Everyone,I want to sync Stock Item Attribute (combo/multi-select combo) Value Description instead of Attribute Value ID at the time of Stock Item Sync from Acumatica to BigCommerce as custom field name and value.From Entity Mapping it is not possible, so I did a customization but observed that one attribute value, updating across all other custom field values.Please find below sample code and screenshots for reference.Sample Code:public class KNBCStockItemProcessorExt : PXGraphExtension<BCStockItemProcessor>    {               public delegate object GetAttributeDelegate(BCStockItemEntityBucket bucket, string attributeID);        [PXOverride]        public object GetAttribute(BCStockItemEntityBucket bucket, string attributeID, GetAttributeDelegate baseMethod)        {            MappedStockItem obj = bucket.Product;            StockItem impl = obj.Local;            impl.Attributes?.Where(x => string.Equals(x?.AttributeDescription?.Value, attributeID, StringComparison.Inva

2
vivekm
Varsity I
2 years ago
K
Freshman II
kirbygompf32Freshman II
asked in Retail-Commerce

Online Credit Card Authorization Form

Hi we have setup a processing center to connect to Authorize.net and have tested successfuly.  Is there any online form or tool to allow customers to enter their credit card information?  I’m surprised I haven’t been able to find anything….customer portal looks like it might have something but I don’t want to give every customer a username/password.   Any suggestions how I can have customers enter their own cc details online for authorization?

2
K
Freshman II
2 years ago

Badge winners

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 — 2023  Acumatica, Inc. All rights reserved