EN
e-Invoice and Tax

How to Set Up E-commerce Integration? A Guide to Data Flow, Product Matching, Test Orders, Single Inventory and Invoice and Shipping Automation

How do you set up an e-commerce integration? Data flow, product matching, test order, single inventory and invoice-shipping automation: an 8-lesson hands-on guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is an e-commerce integration, and why do you need one?
  3. Lesson 2: Which data flows in which direction?
  4. Lesson 3: What preparations are made before the integration?
  5. Lesson 4: How do you check product matching?
  6. Lesson 5: How is the setup done, and why place a test order?
  7. Lesson 6: How is inventory managed from a single source?
  8. Lesson 7: How are invoicing and shipping automated?
  9. Lesson 8: What should you monitor after setup?
  10. What are the most common mistakes in e-commerce integration?
  11. How does NetKasam make e-commerce integration easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Clean up your product codes and barcodes this week
  14. Frequently Asked Questions About E-commerce Integration

Your e-commerce site is running and orders are coming in; but the same process repeats for every order: you open the site panel and copy the order, enter it into the accounting software, issue the invoice, reduce inventory by hand, then type the address into the carrier's screen. Keeping the same information in four places takes time and produces errors; one day an out-of-stock product is sold and the order has to be canceled. E-commerce integration ties this chain to a single record: products and inventory flow from the system to the site, and orders flow from the site to the system.

This article is not a narrative but an 8-lesson hands-on training. We will answer the question how to set up an e-commerce integration with numbers, using an example store that receives 1,050 site orders a month: what integration is, which data flows in which direction, pre-setup preparation, product matching, verification with a test order, managing inventory from a single source, automating invoicing and shipping, and monitoring after setup. At the end there is a mini quiz with an answer key. For the marketplace side, see the article how to choose a marketplace integration; here we connect your own site.

What will you be able to do by the end of this training?

In short: You will draw up a preparation list for the integration, check product matching, verify the flow with a test order, manage inventory from a single source and calculate the time and error savings of the integration.

Training mapThe six steps of an e-commerce integration
  1. 01
    PreparationFix product codes and barcodes.
  2. 02
    ImportBring products into NetKasam first.
  3. 03
    ConnectionConnect your platform.
  4. 04
    MatchingCheck product and inventory matching.
  5. 05
    TestPlace a test order with a single product.
  6. 06
    LiveTurn on invoice and shipping preferences, and monitor.

The 8 lessons of the training: (1) what is an e-commerce integration, (2) data flow, (3) preparation, (4) product matching, (5) setup and test order, (6) single inventory, (7) invoice and shipping automation, (8) post-setup monitoring.

Lesson 1: What is an e-commerce integration, and why do you need one?

In short: Integration eliminates entering the same information by hand in more than one place. Your site is not in one place, your inventory in another and your invoices in a third; they are all tied to a single record.

Without integrationWith integration
Site orders are entered into accounting by handOrders come into NetKasam automatically
Inventory looks different on the site, marketplace and warehouseInventory is managed from a single source
Shipping information is entered separately for each channelA single shipping integration covers all orders
Producing reports by channel is difficultThe sales report is pulled from one place

The common cause of these problems is keeping data in more than one place. With NetKasam, you connect your e-commerce platform; marketplace orders are also managed from the same screen, so inventory for all channels is deducted from a single source. For details, see the e-commerce integration page. For a broader framework, the e-commerce software page helps with choosing a platform. Example store: a seller that receives 1,050 orders a month on its own site and also collects 1,450 orders on three marketplaces.

Lesson 2: Which data flows in which direction?

In short: Products and inventory go from NetKasam to the e-commerce site, while orders go from the site to NetKasam. Invoice and shipping information moves through the order record.

DataDirectionResult
Products and inventoryNetKasam → e-commerce siteInventory is transferred to the site and to sites you provide XML to
OrderE-commerce site → NetKasamSite orders on the same screen as marketplace orders
Inventory deductionFrom the site to NetKasamInventory for site orders is deducted in NetKasam
InvoicingNetKasamAutomatic invoicing, e-Invoice and e-Archive
ShippingNetKasam → carrierSite and marketplace orders through a single shipping integration

You can see which platforms are fully integrated on the integrations page. Products can be sent via XML to platforms that are not on the list; for the method, see the article how to do an XML integration. Since orders also come from marketplaces, you don't have to track site and marketplace orders separately; they all run on the order management screen with status, cancellation and bulk actions.

Lesson 3: What preparations are made before the integration?

In short: For the setup to go smoothly, product codes (SKUs) and barcodes must be consistent, shipping details must be ready and the order in which you will proceed must be clear.

PreparationWhy does it matter?
Consistent product codes and barcodesMatching becomes easier
Product list in one placeNo duplicate records
Platform connection detailsThe connection is set up quickly
Shipping agreement and detailsBarcodes and labels are generated
Invoice preference (automatic/bulk)The flow is clear from the start

For organizing product cards and barcodes, see the articles how to prepare a product card and how to set up a barcode system. If you have an existing product list, import it into NetKasam, then send it to the site; doing the reverse can create duplicate records.

Also assign owners during preparation. Who will fix the product data, who will enter the connection details, who will place the test order and who will approve the decision to go live? In a small team these four tasks may fall to one person, but they need to be in writing; most integration errors are not technical but come from ownerless tasks of the "I thought I'd done that" kind. Scheduling the go-live on a day with low order volume also limits the impact of a possible first-day error.

Lesson 4: How do you check product matching?

In short: The first task after connecting is to check that the products on the site match the cards in NetKasam. When an order comes in for an unmatched product, its inventory is not deducted, or it is deducted from the wrong product.

Chart172 of 200 products are ready at the first check
  1. Products on the site200 products
  2. Code or barcode mismatch−18 products
  3. No card in NetKasam−10 products
  4. Directly matched172 products

Prepared with example values. Ready rate: 86%.

ProblemCountSolution
Code or barcode mismatch18Determine the correct value, fix one side
No card in NetKasam10Create the card, match it with the site
Directly matched172Checked, continue

The 28 problem products are 14% of the total; these are the ones that will cause inventory errors when they are ordered. Taking the site live before matching is complete becomes the source of orders canceled in the first week. To weed out duplicate barcodes and codes, use the cleanup method in the article how to set up a barcode system.

Recommended ReadingHow to Do an XML Integration?

Lesson 5: How is the setup done, and why place a test order?

In short: Setup is done in five steps: free sign-up and product entry, platform connection, product and inventory transfer, shipping and invoice preferences, and monitoring. Place a test order with a single product before going live.

StepWhat to do?Control
1Sign up for NetKasam, enter or import productsProduct count is correct
2Select the e-commerce platform and set up the connectionConnection is active
3Transfer products and inventory to the siteCorrect inventory shows on the site
4Set up shipping integration and the automatic invoicing preferencePreference is saved
5Monitor orders and inventory from a single screenTest order processed correctly

In the test order, check the following: did the order come into NetKasam, did inventory decrease by one unit, was the invoice created in the right type (e-Invoice or e-Archive), was the shipping label generated? These four checks reveal most of the errors you would encounter in the live flow. On the pricing and plan side, bookkeeping is free; e-commerce integration is included as 1 integration in the Global Plus plan, and the current scope is on the pricing page.

Lesson 6: How is inventory managed from a single source?

In short: When the site and marketplaces share the same inventory, the risk of selling products you don't have decreases. The inventory for every order is deducted from the same record.

Chart1,050 of 2,500 monthly orders come from your own site
  • Your own e-commerce site₺1,05042%
  • Marketplace 1₺78031.2%
  • Marketplace 2₺47018.8%
  • Marketplace 3₺2008%

Prepared with example values. Site share: 42%.

When 42 percent of orders come from the site and the rest from marketplaces, keeping inventory in four separate places requires a separate count and separate corrections in each channel. With a single source, when the last unit of a product is sold in one channel, it is reflected in the other channels. For managing store and online inventory together, see the article how to manage store and e-commerce inventory in one place, and for syncing across channels, see how to sync marketplace inventory.

ChartOrders canceled because of inventory: from 14 to 3 a month after integration
  1. Before integration14 orders
  2. First month5 orders
  3. Third month3 orders

Prepared with example values. The cancellation rate falls from 1.33% to 0.29% (3 ÷ 1,050).

14 cancellations a month with an average basket of ₺480 means a loss of ₺6,720 in sales; with 3 cancellations, this amount drops to ₺1,440. The difference is ₺5,280, and the impact on customer trust and store rating also decreases.

Lesson 7: How are invoicing and shipping automated?

In short: When an order comes into the system, the invoice is issued automatically or in bulk, shipping is passed on through a single integration and the collection is posted to the customer account. The flow is the same whatever the source of the order.

FormulaFour formulas that measure the impact of integration
  1. Manual time = Number of orders × (Entry time + Invoicing time)
  2. Time with integration = Number of orders × Checking time
  3. Time saved = Manual time − Time with integration
  4. Inventory cancellation rate = Cancellations due to inventory ÷ Orders × 100

Prepared with sample values.

ItemManualWith integration
Order entry (per order)3 min0 min
Invoicing (per order)2 min0 min
Checking (per order)0 min0.5 min
Monthly time for 1,050 orders5,250 min (87.5 hours)525 min (8.75 hours)

The time saved is 87.5 − 8.75 = 78.75 hours; that is about 10 working days. For the invoicing setup, see the article how to invoice orders in bulk, and for shipping setup, see how shipping integration works and how to choose one. For the full journey of orders, the article how to manage orders in e-commerce is a good complement.

Takeaways from the exampleThe example store in four numbers
  • 86%products directly matched at the first check (172 / 200)
  • 78.75 hourstime saved per month
  • 14 → 3orders canceled each month because of inventory
  • ₺5,280monthly sales no longer lost

Lesson 8: What should you monitor after setup?

In short: Setup is done once, but monitoring continues. New unmatched products, inventory differences and orders that could not be invoiced should be checked weekly.

When?What to do?Who?
Every new productThe card is created in NetKasam first, then sent to the siteProduct manager
WeeklyOrders with inventory differences and orders that could not be invoiced are listedAccounting
MonthlyThe number of inventory-related cancellations and the time savings are calculatedManagement
When the platform changesMatching and the test order are repeatedManagement
Once a quarterThe sales and profit report by channel is reviewedManagement

To see profitability by channel, you can use the profit margin calculator, and to save reports, the reports screen. For a general checklist for moving to another system, see the article how to transfer data when changing accounting software.

Recommended ReadingHow Do You Manage Store and E-Commerce Inventory from One Center?

In monthly monitoring, write down two numbers in particular: the number of orders canceled because of inventory and the number of orders that could not be invoiced. The first shows the health of inventory matching, the second the health of customer and product data. If both stay low for several months in a row, the integration has settled; if they start to rise, it is usually a sign that newly added products are being created without following the rules, and the fix should go back to the new product entry rule.

What are the most common mistakes in e-commerce integration?

  1. Entering products on the site first, then in NetKasam. Duplicate records are created.
  2. Connecting without cleaning up codes and barcodes. Matching problems surface in the live flow.
  3. Not placing a test order. The error is first seen with a real customer.
  4. Managing inventory from two places. Products you don't have get sold.
  5. Not setting the invoice preference at the start. Invoicing is delayed.
  6. Creating new products only on the site. Inventory is not deducted for a product with no card in NetKasam.
  7. Not monitoring at all after setup. Matching breaks down and goes unnoticed.

How does NetKasam make e-commerce integration easier?

  • Orders on one screen. Site and marketplace orders are gathered in the same list (order management).
  • Product and inventory transfer. Products and inventory are transferred to the site and to the sites you provide XML to.
  • Automatic or bulk invoicing. With e-Invoice and e-Archive (e-Invoice).
  • A single shipping integration. Site and marketplace orders are passed to shipping through the same integration (shipping integration).
  • A single report. You track sales by channel in reports.
  • You keep your existing platform. You don't need to switch to a new platform; products are sent via XML to platforms that are not on the list.
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; e-commerce integration is included as 1 integration in the Global Plus plan (pricing).

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. 255 of 300 products match directly. What is the ready rate?
  2. With 600 orders a month, if manual entry takes 3 min and invoicing 2 min, how many hours is the total time?
  3. If checking with integration takes 0.5 min per order, how many hours do the same 600 orders take?
  4. In what order should products be transferred?
  5. What is checked in the test order before going live?

Answer key:

  1. 255 ÷ 300 × 100 = %85.
  2. 600 × 5 = 3,000 min = 50 hours.
  3. 600 × 0.5 = 300 min = 5 hours.
  4. First to NetKasam, then to the site; the reverse can create duplicate records.
  5. That the order comes in, inventory decreases, the invoice is created in the right type and the shipping label is generated.

Frequently Asked Questions About E-commerce Integration

What is an e-commerce integration?

It is the automatic communication of the products, inventory and orders on your own e-commerce site with your accounting and marketplace system.

Which data flows in which direction?

Products and inventory go from NetKasam to the e-commerce site, while orders go from the site to NetKasam. Invoice and shipping information moves through the order record.

Do I need to switch to a new platform?

No. NetKasam works with many platforms; you connect your existing platform. Products can be sent via XML to platforms that are not on the list.

In what order are products transferred?

First import your existing product list into NetKasam, then send it to the site; doing the reverse can create duplicate records.

Are site and marketplace orders tracked separately?

No. They are all gathered on the order management screen; status, cancellations and bulk actions are handled from there.

How is the invoice issued?

Orders are converted into e-Invoices or e-Archive invoices automatically or in bulk.

Which plan includes e-commerce integration?

Bookkeeping is free; e-commerce integration is included as 1 integration in the Global Plus plan. The current scope is on the pricing page.

What should I do before going live?

Place a test order with a single product and verify that the order comes in, inventory decreases, the invoice is created and the shipping label is generated.

Conclusion: Clean up your product codes and barcodes this week

E-commerce integration is less a software installation than a matter of data discipline. This week, compare the products on your site with your NetKasam cards, fix code and barcode mismatches, then place a test order with a single product. When matching is clean, orders, inventory and invoices flow without manual work; you can spend the rest of your time growing sales.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeFree e-Invoice System

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools