Mimovrste distinguishes the suppliers to:
- Local supplier: products are sent to the MV warehouse from where they are sent to the customer. In that case, only the connection via EDI standard for collective documents (purchase order, delivery notes, goods received notes, invoices) is possible, the method that MetaKocka does not support.
- Marketplace supplier: MV collects orders and issues invoices. The supplier delivers the products to the customer on its own. This integration MetaKocka supports and enables the following:
- Transfer of products from MK -> Mimovrste
- Transfer of prices and product stock from MK -> Mimovrste
- Retrieving Mimovrste orders -> MK
To establish a Marketplace supplier, please get in touch with your administrator.
- Establishing a connection with the Mimovrste store
Requested data: API key
MallGroup portal link: https://new-partners.mallgroup.com/partner/
The API key can be obtained on the MallGroup partner portal, under the ''Partner'' sub-menu as displayed in the picture below.
Slika 1:Mallgroup partner API key
In MetaKocka - Additional settings, click on the ''Online stores'' to add a new store. Entering the store name and API Key is required, as well as selecting where the order will be transferred from the online store.
Picture 2: MetaKocka adding an online store
On the stores list, select the added store. A display similar to the one in the Picture 3 will be available. A warehouse for stock synchronization needs to be chosen. Once this is completed, click the ''Test connection'' button. If the connection test is successful, MetaKocka is connected to Mimovrste. If the test proves to be unsuccessful, check again if the API key is correctly entered.
- Functionalities
Picture 3: MetaKocka store functionalities
- Display category data and Prikaži podatke kategorij in oznak
Information about categories, parameters, and product tags can be obtained by following this procedure:
- Select the ''Category'' field and click the ''Show category and tag data'' button. The list of all categories in the format ''ID: Description'' will open.
- Search for preferred categories, enter their IDs (Example: EA001, EG013), and close the window.
- Into the text field ''ID, ID, ID,..'' enter selected IDs in the displayed format, select the ''Categories and labels'' field, and click the ''Show category and tag data'' button again.
- Data will be displayed in the same way as before, but only for the entered categories. In addition, the tags will always be shown below.
- If only the tags should be displayed, the text field should be left empty, and step 3 should be executed..
- Sync products to website
When using this functionality, all products, tagged for Mimovrste, will be transferred to the online store. Already existing products in the online store will be updated, while the others will be added. The product data will be transferred, as well as its stock and its price.
- Sync Product stock
If product stock should be manually synced on Mimovrste, this can be done by pressing this button. Since this functionality calls the same API »endpoint«, as product synchronization to the web page, it is suggested to synchronize all products belonging to a set, instead of doing so to all products. (point 2.b).
- Sync product prices on the web page
If product price should be manually synced on Mimovrste, this can be done by pressing this button. Since this functionality calls the same API »endpoint«, as product sync to the web page, it is suggested to synchronize all products belonging to a set, instead of doing so to all products. (point 2.b).
- Order transfer
By using this button, orders can be manually transferred. Specifying for how many days
Specifying for how many days in the past the orders should be validated is required. Furthermore, if the specific orders should be transferred, their IDs can be entered and the transfer can be executed.
Orders are transferred automatically if such an option is activated in »Settings«
- Preparing and importing products
Before synchronizing products to Mimovrste, products must be tagged in MetaKocka and their content sent to Mimovrste should be set. This can be done by importing the Excel file for product change.
MetaKocka -> Settings -> Data import -> File – select the file, Data type – ''Products – change”
The Excel file for product change is a standard one and it is downloaded from MetaKocka. First, set the column for product identification and then add the following columns. If products have variations, also fill in the columns for variations (3b).
- Main product data
- Bar-code: maximum of 13 characters,
- MallGroup: Yes/No (Is the product added or deleted),
- Stage: draft/live,
- VAT: 9,5 or 22,
- short_desc: brief description
- long_desc: long description
- priority: a larger number has a higher priority in the list
- price: main price, including VAT. This price is displayed on Mimovrste.
- purchase_price: if ''price'' is not set, this price is used,
- rrp: the suggested retail price. On Mimovrste this price is crossed out and ''price'' represents discounted price.
- media: link1;link2,...
- Suggested formats: jpg, png, gif,
- picture format: 4:3 or 3:4,
- maximum size: 1,5 MB,
- separated by semicolon ";",
- first picture in the list will be marked as the main product picture.
- pictures must be readily available on the provided links.
- labels: ID/date from/date to;...
- Example: SALE/2020-04-19 00:00:00/2020-06-14 23:59:59,
- dates must always be in the future,
- values separated by ''/'', sets with ";".
- availability_status: A/N (available/not available),
- delivery_delay: estimated number of days for delivery/shipping. 0 = product can be delivered on the same day,
- free_delivery: yes/no,
- recommended: productID1,productID2,...,
- package_size: smallbox/bigbox,
- mallbox_allowed: yes/no,
- Parameters:
- Empty column: Before parameters, there should be one empty column.
- Product parameters follow up. Valid parameters (column name) and their values can be obtained through additional settings, as mentioned in 2a. For each product fill in as many parameters as possible, since it can happen that Mimovrste will not let through the publishment of the product.
- Multiple values for one parameter can be entered as a list, where the separator is semicolon ( ; ). (value1;value2;value3;...)
- partner_title: Company name
- Variations
- variants: productID1,productID2,...,
- Specify which products are the variations of the selected product.
- parent: productID,
- Specify to which product that variation belongs
- variable_params: param1,param2,...,
- These are the parameters by which variations differ on the website. Parameters have the same name as category parameters (Example: INPUT, VOLTAGE, THREAD,...)
- Values are entered only for the main product.
- Both values should be ALWAYS entered. "variants" for the main product and ''parent'' for the product variation.
- variants: productID1,productID2,...,
Variations are made up of the main product and variations. On Mimovrste, only product variations are displayed. Example:
- Product is added to Mimovrste = added product is visible,
- Variation is added to the product = only that product variation is visible and not the product added before,
- Variation is added to the product with the same data as in point 1 = both products are visible
A variation uses "category_id" from the main product, so this does not have to be set, while the category parameters have to.
The following values do not have to be recorded for the main product, but only for its variation:
- price, purchase_price, rrp , bar-code, media, labels, recommended
- Mandatory data according to the type
- Product:
- category_id, stage, vat, id, title (from MK), short_desc, long_desc, priority, media, availability_status, zaloga (from MK), package_size
- Variation:
- id, title (from MK), short_desc, long_desc, priority, media, availability_status, zaloga (from MK), package_size
- Labels:
- ID, date from, date to
- Product:
- Discounts:
- Discount is set by using the ''price'' parameter. The percentage depends on the selling price in the last 30 days.
- If the product is a new one and it should be immediately displayed with a discounted price, the product price should be set first, then the product should be synced to the online store, following the price change, and finally, it should be resynced.
- More information: https://knowledgebase.mallgroup.com/en/stitky-a-akcni-cena/
- Deleting products:
- MallGroup: No
- When deleting products, the Excel file is imported for the product change, where aside from columns for product identification, the MallGroup column is set to ''No''. Other Mimovrste data is not mandatory. By applying this, in MetaKocka the product is marked for deletion. To remove the product from the product list on Mimovrste, synchronizing products to the website in additional settings is required.
More information regarding product data can be found at the link:
Example of product import: