(Simple) Items
1. Upload to Shopware
To enable items to be uploaded to Shopware, the Item Card has been extended with additional functions.
Default mapping of fields between BC and Shopware:
No.
Product number (productNumber)
Description
Name
Marketing Text
Description (HTML)
Unit Cost
Purchase price
Unit Price
Price
GTIN
EAN
Base Unit of Measure
Unit
To open the overview of all items in Business Central, navigate along the following path: "Sales" "Items".
To make the following settings, select an existing item or create a new item in Business Central.
How do I create an item correctly?
Microsoft provides comprehensive instructions and notes on creating items in Business Central. Follow this link:
The item attributes are displayed. The following two screenshots show a standard view of an item with all editable properties. These can be adjusted individually depending on your settings. This explanation assumes the standard view.
The individual fields are explained below.
An item can be uploaded to Shopware if the following fields are filled in on the Item Card:
No.: The content of this field becomes the product number in Shopware.
Description: The content of this field becomes the product name in Shopware.
Blocked: This field determines whether the item is displayed in the online shop or remains deactivated.
Base Unit of Measure: The content of this field becomes the unit of measure in Shopware (found under "Specification").
GTIN (visible when you select "Show more"): Defines the GTIN in Shopware.
Item Category Code: The category stored here is the BC-native one. As a rule, it is only used to sort the item within Business Central. However, it is also possible to store a category that has been uploaded to Shopware as a web category.
Shopware Categories: Here you can store item categories for Shopware. It is also possible to assign an item to several categories, which is otherwise not possible in standard BC. You can find out more under Item Categories.
2. Item Card description
In the standard view, Picture, Marketing Text and Item Attributes are located on the right-hand side of the BC window.
Picture
Editing is described in the section Item Pictures. For more information, please go to that section.
Marketing Text
The marketing text becomes the product description in Shopware. It is transferred as HTML code, so formatting such as bold or italic is also possible.
Item Attributes
Editing is described in the section Item Attributes. For more information, please go to that section.
For extended product descriptions, for example using attribute-based text modules, please contact our support team: Support Contacts
Inventory
The Inventory field takes the stock available for the shop from the inventory settings stored in the configuration.
Inventory: The "Inventory" field fills the inventory in the shop based on the inventory settings configured in the setup.
Unit costs and posting
Unit Cost Not relevant for the display in the online shop, as this is the purchase price. It is not transferred and therefore cannot be found in the shop either.
VAT Prod. Posting Group (visible when you select "Show more"): Responsible for assigning the tax rate in Shopware.
The VAT mapping is described in Order Configuration. This mapping must be carried out once!
Shopware information
Web Item YES: Only if Web Item is set to YES can the item be uploaded to the shop.
Please note: This does not upload the item to Shopware automatically. You trigger the upload under Actions Shopware Upload product.
Parent No. If this item is set up as a variant, you will find the parent item here.
Shopware Active YES: The item is not only uploaded to Shopware but also activated there.
Out of Stock YES: Regardless of the inventory in BC, the item is set to "out of stock" in Shopware.
Web-ID The Web-ID is filled in automatically after a successful upload to Shopware.
Imported YES: the item has been imported, otherwise NO.
Synchronized On Date of the last synchronization with Shopware.
Inventory Quantity Synchronized
Inventory Quantity Synchronized On Date of the last synchronization with Shopware.
Price Synchronized
Price Synchronized On Date of the last synchronization with Shopware.
Synchronization Message Indicates whether the last synchronization with Shopware was successful. If it failed, the error that occurred is shown.
Sales Channel
On the Sales Channel tab, you can define which Shopware sales channel the product is intended for. Assigning an item to several sales channels is also possible here.
Price & Sales, Replenishment, Planning, Item Tracking and Warehouse
The following screenshot illustrates the standard display of the remaining sections. These fields are:
3. Additional options
To define the units of measure of an item in more detail, follow this path:
Related Item Units of Measure
For example, the weight or the quantity per unit (for instance for "sets of 3") can be defined.
On the Actions Shopware tab you will find not only the "Upload product" button for uploading the product to Shopware, but also further functions:
Import default pictures
COMING SOONPrice list line
COMING SOONReset synchronization status
COMING SOON
4. Summary
Flag an item as a web item
For an item to be synchronized to Shopware, it must be flagged as a web item:
Open the Item Card.
Scroll to the Shopware Information section.
Set Web Item to Yes.
Automatic synchronization
Create a Job Queue Entry.
Select the Item Upload codeunit.
Define the interval.
5. Tips for day-to-day use
Maintain complete item data (name, description, pictures).
Use meaningful item numbers.
Check the VAT mapping before uploading.
Upload large catalogs outside business hours.
Use filters for selective updates.
Monitor the Activity Log.
New items may still need to be assigned to a sales channel in Shopware before they are visible in the shop.