A Magento 1.9's module to export products informations, inside a chosen date range, to a .XLSX file.

Matheus Delazeri

Last update: Oct 12, 2021

Related tags

E-commerce magento-export

Overview

Magento 1.9 Export products module

A magento 1.9 module to export products informations to a .XLSX file.

Module informations

Package/Namespace: "Matheus"

Modulename: "Export"

codepool: "community"

How to install

Add the folder Matheus inside /app/code/community/ and add the file Matheus_Export.xml inside /app/etc/modules/

How to use

After installation a new submenu named Export Products will be created at the menu Catalog in your admin panel. Click in it to enter the module's page.

Now, you just need to select the date range and press the button Export to generate a .XLSX file, that will be automatically downloaded in your browser, containing the meaningful informations about the products in your store registered inside the chosen date range.

The .XLSX file

The sheet generated by the module will be split in 2 different pages:

All products
Association

The page All products will have all the info about the products:

store	websites	attribute_set	type	categories	sku	name	price	special_price	weight	status	visibility	tax_class_id	description	short_description	qty	is_in_stock	store_id	created_at
admin	base	default	configurable	Default Category	product-sku	Product name	100	60	1	1	4	none	description	short description	5	1	0	2021-05-15

Obs.: custom attributes (like color, size, etc) will be placed after the last column in the page All products

And the page Association will have the info about the association between configurable products and their children:

sku	_super_products_sku	_super_attribute_code	_super_attribute_option
configurable-sku		size
	child-product-P	size	P
	child-product-M	size	M

You can also check the Example Sheet.xlsx to see which infos are stored.

You might also like...

Prestashop module for Orange Money web payment in Central Africa

PrestaShop payment module which allow to add African (Cameroon, Cote D'Ivoire etc...) Orange Money payment method on our website

9 Jul 29, 2022

Example of Pre-Loader Implementation for Magento 2

Example of preloader Implements optimistic preloader for configurable product data without taking into account simple product status for: Price of con

10 Dec 12, 2021

Magento 2 Facebook Pixel Extension

Magento 2 Facebook Pixel Extension Enable Facebook Pixel on Magento 2 website Requirements Magento Community 2.3.0-2.4.x (CE, EE, ECE, B2B) Magefan Co

13 Jul 13, 2022

Magento 2 configurable product options

Magento 2 Configurable Options This module provides functionality for preselecting configurable product options and updating attribute values from sel

14 Jun 9, 2022

Magento 2 Share Cart extension Free

Mageplaza Share Cart Extension helps customers in sharing their shopping cart with friends and family as well. This is a supportive method to promote store’s conversion rate via the existing users, and this can significantly contribute to the revenue of the store.

12 Jul 22, 2022

Metamask & web3js Ethereum payment method extenstion for Magento 2 without any third party gateways

CurrencyPrecision Magento 2 Extension Metamask Ethereum payment method module for Magento 2 Table of contents Description Feature Installation Compose

16 Nov 22, 2022

Import data from and export data to a range of different file formats and media

Ddeboer Data Import library This library has been renamed to PortPHP and will be deprecated. Please use PortPHP instead. Introduction This PHP library

570 Dec 27, 2022

Magento 2 Module for parsing xlsx, xlsm and csv files from Excel

Magento 2 Spreadsheet Parser Facts Parse XLSX, XLSM and CSV Files from Excel Requirements PHP = 7.0.* Magento = 2.1.* Compatibility Magento = 2.1 U

9 Sep 24, 2020

Automatically load the next page of products in Magento. Easy to install and configure, this module works 100% out of the box with vanilla Magento 1.9.x and earlier.

123 Nov 20, 2021

Date/Time Picker widget for Yii2 framework Based on Eonasdan's Bootstrap 3 Date/Time Picker

Yii2 Date/Time Picker Widget Date/Time Picker widget for Yii2 framework Based on Eonasdan's Bootstrap 3 Date/Time Picker Demo Since this is a part of

8 Mar 14, 2022

This is an experiment to export all RFCs from the PHP wiki into Git, including the change history for each RFC (along with the date and author of each change). This is not meant to replace the wiki.

PHP Requests for Comments (RFCs) About This repository is an experiment to export all RFCs from the PHP wiki into Git, including the change history fo

34 Jun 20, 2022

A high-performance license server system service for creating and managing products, major versions, and software licenses for the purpose of selling installable software products.

A high-performance license server system service for creating and managing products, major versions, and software licenses for the purpose of selling installable software products. Comes with a SDK and command-line tool. Works anywhere that PHP runs.

32 Dec 5, 2022

A tool that allows to quickly export data from Magento 1 and Magento 2 store and import it back into Magento 2

Simple Import / Export tool A tool that allows to quickly export data from Magento 1 and Magento 2 store and import it back into Magento 2. Table data

51 Dec 5, 2022

🍪 Write gorgeous documentation for your products using Markdown inside your Laravel app.

LaRecipe Write gorgeous documentations for your products using Markdown inside your Laravel app. LaRecipe 🍪 LaRecipe is simply a code-driven package

2.1k Dec 29, 2022

Magento 2 module to quickly acces products, orders and customer from admin menu

Magento 2 module to quickly access product, order or customer views Introduction The Magento 2 backend can be sluggish. Ever wanted to access a produc

1 Dec 3, 2021

File Upload widget with multiple file selection, drag&drop support, progress bar, validation and preview images, audio and video for jQuery. Supports cross-domain, chunked and resumable file uploads. Works with any server-side platform (Google App Engine, PHP, Python, Ruby on Rails, Java, etc.) that supports standard HTML form file uploads.

jQuery File Upload Contents Description Demo Features Security Setup Requirements Mandatory requirements Optional requirements Cross-domain requiremen

31.1k Jan 8, 2023

Magento-bulk - Bulk Import/Export helper scripts and CLI utilities for Magento Commerce

Magento Bulk Bulk operations for Magento. Configuration Copy config.php.sample to config.php and edit it. Product Attribute Management List All Attrib

23 Dec 20, 2022

Platform to get informations about any country.

OpenCountries This project is a web platform developped in PHP implementing the RestCountries API. The objective of the project is to get informations

3 May 2, 2022

Fausse page de connexion faite en PHP, inclu: blacklist IP, redirection au choix, webhook discord, logs. Pour les informations: IP, mdp, email, géolocalisation, navigateur et bien d'autre

Page de phishing pour facebook 1. Informations Page de phishing simulant la page de connexion PayPal. Faite en php, elle fournit: email mot de passe I

10 Dec 5, 2022

Comments

Can't find the submenu

Hello, Magento newbie here.

i installed the script and everything but i can't find the submenu, is there something i should run ? cache i should delete or something ? maybe activating the plugin like we do on wordpress.

thanks

opened by khalidelmerrah 2