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

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.

image

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.

image

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 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

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

Magento 2 Facebook Pixel Extension
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

Magento 2 configurable product options

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

Magento 2 Share Cart extension Free
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.

Metamask & web3js Ethereum payment method extenstion for Magento 2 without any third party gateways
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

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

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

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.

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.

Date/Time Picker widget for Yii2 framework Based on Eonasdan's Bootstrap 3 Date/Time Picker
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

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

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.

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.

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

🍪 Write gorgeous documentation for your products using Markdown inside your Laravel app.
🍪 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

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

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

Platform to get informations about any country.
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

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
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

Comments
  • Can't find the submenu

    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
Owner
Matheus Delazeri
Information Systems student at Federal University of Santa Maria.
Matheus Delazeri
An eCommerce website is an online store where you can buy or sell products online. An eCommerce offers a professional online store builder that helps you launch your eCommerce business quickly and successfully.

An eCOMMERCE-SITE An eCommerce website is an online store where you can buy or sell products online. An eCommerce offers a professional online store b

UTTKARSH PARMAR 2 Aug 8, 2022
An E-Commerce package for Laravel with Grafite CMS. Take control of your content and how you sell it! Products, subscriptions, shipping, downloading and more!

Grafite Commerce Grafite has archived this project and no longer supports or develops its code. We recommend using only as a source of ideas for your

Grafite Inc 45 Jun 8, 2021
Laravel eCommerce Pre Order Extension allows the customers and guest users to pre-order the upcoming product and out of stock products.

Introduction Bagisto Pre-order add-on allows the customer to pre-order products which are not yet available at the online store. With the help of Bagi

Bagisto 3 May 31, 2022
AbanteCart is a free PHP based eCommerce solution for merchants to provide ability creating online business and sell products online quick and efficient.

AbanteCart is a free PHP based eCommerce solution for merchants to provide ability creating online business and sell products online quick and efficient. AbanteCart application is built and supported by experienced enthusiasts that are passionate about their work and contribution to rapidly evolving eCommerce industry. AbanteCart is more than just a shopping cart, it is rapidly growing eCommerce platform

AbanteCart 129 Nov 15, 2022
The Laravel eCommerce DHL Shipping module module calculates the shipping rates based on DHL API for product shipping.

Introduction DHL Shipping Add-on provides DHL Shipping methods for shipping the product. It packs in lots of demanding features that allows your busin

Bagisto 1 May 31, 2022
Magento 2 module to only allow checkout when the number of items in the cart are a multiple of X.

Cart Quantity Multiple - Magento 2 Module Introduction This module allows to limit checkout only when the contents of the cart are a multiple of X

ADVOCODO 3 Apr 7, 2022
Magento 2 Module: OrderConfirmationEmailStatus

Magento 2 Module: OrderConfirmationEmailStatus Main Functionalities Installation Main Functionalities This module adds a column in the sales order gri

null 1 Jan 21, 2022
PrestaShop module that allows an ecommerce/brand to display its physical retailers in a map

PrestaShop module that allows an ecommerce/brand to display its physical retailers in a map Features Free of charge: instead of using pa

Darío Scattolini 3 Apr 15, 2022
A small module allow user to add a real top banner in PrestaShop

Lk Top banner A simple module that allow you to add a real Top banner message in PrestaShop Options module Add any long or tiny text and eventually yo

Azralth 2 Sep 25, 2021
Paypal module for Thelia ecommerce solution

PayPal I) Install notes II) Configure your PayPal account III) Module options payments I) Installation Composer WARNING : A console access is required

null 8 Nov 22, 2022