CSV import and export for bulk catalog management
Import and export products via CSV with async jobs — practical workflows for bulk updates, migrations, and inventory sync.
Adding three hundred SKUs by hand before a seasonal launch is a mistake you only make once. Mrfqy's CSV import and export runs as background jobs so you can upload a spreadsheet, fix validation errors, and continue managing orders while processing completes. This guide covers column expectations, safe update patterns, and honest limits.
Export your catalog as CSV
From Products → Export, download a CSV snapshot with SKUs, titles (AR/EN), prices, stock, tags, and collection handles. Use exports as backups before bulk edits or migration to Mrfqy from another platform.
Schedule exports before Ramadan and Black Friday campaigns so you have rollback data if bulk price updates go wrong.
Large catalogs export asynchronously — email or in-app notification arrives when the file is ready; do not click export repeatedly.
CSV column format and validation
Required columns typically include SKU, title_ar, price, and product type. Optional columns cover English titles, compare-at price, stock quantity, barcode, weight, and tags separated by semicolons.
Validation runs row-by-row: duplicate SKUs, negative prices, and invalid collection handles fail with line numbers in the job report. Fix CSV locally in Excel or Google Sheets, then re-upload — do not partial-fix inside the admin grid during the same job.
UTF-8 encoding is mandatory for Arabic text. If Excel mangles characters, import via Google Sheets export or LibreOffice with explicit UTF-8.
Async jobs and progress tracking
Imports enqueue as background jobs so browser timeouts do not truncate ten-thousand-row files. Job status shows processed, succeeded, and failed counts with downloadable error CSV for failed rows only.