Free video trainings on Merlin Backoffice ® Flex
The tutorials of all other modules than Merlin Backoffice ® are located in the modules' page itself.
This page does not cover all technical subjects. There are some other tutorials, made of text and screeen capture in our Knowledge base.
Getting started
Foundational training for Merlin Backoffice entry level training on Merlin Backoffice : installation, first view, showing products, bulk editing, main features..."
Move products, assign them to categories, order them, and count them
All methods and tools to master catalog organization with Merlin Backoffice: default vs. secondary categories, drag-and-drop, cross-assignments, product counters by category/branch, upward associations, product positions, and more.
Promotions, sales, special & tiered prices, and group discounts
How to enter, bulk-edit, round, or import special/tiered prices for many products/variations in PrestaShop; bulk price edits; and applying discounts to customer groups and categories.
Create, edit, and assign customer groups; group–category relations
Deep dive into managing customer groups in Merlin: creating groups, assigning to customers, bulk edits, quick category assignments, and group-based special pricing.
Must-know: bulk text editing (names, descriptions, SEO, features, barcodes, refs, …) with MagicEdit
MagicEdit lets you bulk-edit any text column (names, descriptions, SEO, refs, EAN/UPC, out-of-stock messages, …). Chain powerful functions: find/delete, find/replace, prepend/append, copy/concat columns, convert HTML↔text, generate barcodes, series of refs, copy/paste from Excel, and more.
Methodology to build a new catalog without file imports
For single or multistore setups: methodology to create a category tree (multi-language) and a new product collection efficiently in Merlin. Covers translations, associations, mass edits, data copy, photo association, URL generation, product duplication, HTML editors, combinations, features, etc.
Change display order (positions) of categories, products, features, attributes & photos; sorting & grouping
Techniques to order rows in Merlin and on your shop using position fields; advanced tricks with MagicEdit series generator; sorting options; and grouping (breaks) on multiple levels.
Everything about product “features”
Comprehensive training: display, export, create, edit, duplicate, translate, delete; order; upward filtering; CSV/Excel imports; standard vs. custom features; multi-values; multistore; UI tips like breaks and using MagicEdit in the Features tab.
Attributes & combinations: create, edit, duplicate, with/without the advanced generator
All about attribute groups, attributes, and product combinations: display, bulk edits, manual creation, delete/duplicate, multistore, properties and order, batch replacements, translations; then a deep dive into the advanced generator & impact editor.
Tags, keywords, meta keywords — differences & how to manage them
Short but complete: display, create, import, duplicate to multiple products, translate, delete; the key bulk operations; and importing from CSV/Excel.
Assign accessories to your products
Three-part tutorial: the Accessories tab (cross-assign in bulk), merging accessory lists between products, and importing accessory lists from CSV/Excel.
Bulk cross-assignments between products, carriers, and attachments
Be fluent in minutes with the Carriers and Attachments tabs to associate them to products in bulk.
Bulk edits, part 1: calculator for numeric fields & margin management
Use the mass calculator to modify numeric fields (prices, stock, weight, …) and set/keep commercial margins when editing or importing purchase prices.
New: bulk edits, part 2 — MagicFormula for numbers & text
Super-powerful yet simple: apply math & string functions to live data or compute non-native metrics (e.g., markup rate, revenue per product, volume, …), and enrich imports by calculating missing columns.
Round prices & build psychological pricing on products, combinations, and discounted prices
How to choose the right method when products have combinations and special/tiered prices; multiple detailed examples.
Cross-link suppliers, manufacturers (brands) & products — supplier references
Manage suppliers in Merlin: display/edit main supplier refs, bulk associations, auto-fill supplier prices, clone refs & purchase prices from products to combinations, generate refs with MagicEdit, CSV/XLS import, obsolescence rules, and supplier/manufacturer prefilters.
Catalog administration in multistore
For multistore admins: product/category associations to stores, single vs. multistore editing, languages, features, special prices, images; multistore import settings (choose target store(s)); root category, default stores, per-store default categories, and automatic repairs.
Create & print price/sale labels and barcodes in endless styles
Three parts: the built-in generator, the pro label generator, and a gallery of advanced examples.
Display, edit, associate, and import photos
Display/administer product images; tools to sort, tidy, purge cache, and clean the server; all techniques to add/replace photos (uploads, auto-association, …); CSV/XLS image imports; bonus: build a new catalog from a batch of photos.
Variant images
A smart tool that finds the right images and matches them to the right combinations (e.g., by color comparison).
Advanced stock & warehouses
Intro to PrestaShop’s advanced stock mode, then how to enable & use it in Merlin: bulk enablement, warehouse assignments, storage locations, all stock moves (re-stock, destock, transfers), supplier purchase prices, stock value, coverage calculation, and more.
Export the catalog to CSV, XLS, XML, PDF
Export all/part of your catalog to multiple formats: PDF for sharing/printing; CSV/XLS/XML for price engines/marketplaces; and formats compatible with re-import via Merlin (e.g., during migrations).
Basics of importing from Excel or CSV
Two-part training: quick tour of the 5 steps & core principles (mapping, sync keys, duplicates, options), plus a fast overview of advanced options.
Detailed import of products, combinations & categories — part 1/2 (products & categories)
A comprehensive example covering a single file that contains products, combinations, attributes, categories, features, images, … Each column & option explained. Equivalent to the 3-hour paid 1-to-1 training, adapted for Merlin.
Detailed import — part 2/2 (attributes & combinations)
Continuation of the exhaustive CSV/Excel import case when the file mixes products & combinations. Part 1 is a prerequisite.
Export / import categories
Migrate categories from one PrestaShop to another, or import them from CSV/Excel. Export your tree to re-import it with IDs and URLs preserved; import trees split across multiple columns; include category translations, and more.
Scheduling & automating imports and updates
In-depth presentation of the scheduler bundled with the CSV/XLSX importer to run catalog imports or product updates (categories, specific prices, images, …) fully automatically on a recurring schedule.
Find and fix duplicates
Understand product/combination duplicates and use the built-in automatic fix tool included in the importer.
Display & edit non-standard or custom data
Yes, Merlin can display/edit custom fields (e.g., a second product description or MSRP). Learn how to use Merlin’s five custom columns to work with such data.
Repair PrestaShop tree, structure & data
Included with category management: a powerful DB repair tool that has saved many shops after crashes. Fix missing/duplicate root, levels, breadcrumbs, orphan products/categories, multistore associations, default-store assignments, position series, missing translations, and more.
New: all search & filtering tools for products and combinations
There are many ways to find products/combinations in Merlin. We revisit the “classic” methods and introduce the quick search and the powerful advanced search & filtering tool.
New: physical stock inventory tool
Designed for merchants with real physical stock and annual inventories. Create one or more inventory files by scanning EAN-13, merge them, compare expected vs. found quantities, import to sync stock and report losses.