Vote to Improve PrestaShop

PrestaShop Forum: Build a free online shop. Count on the Community!

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum: Build a free online shop. Count on the Community!

Jump to content

 
Photo

[MODULE] Product Export Module v2.0 (UPDATED FOR 1.6) (free)

export products free module

  • Please log in to reply
575 replies to this topic
leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 10:51 AM

*
POPULAR

UPDATE v2.0

Complete Rewrite for Prestashop 1.6+

 

The module now exports the exact data set you need to import back into Prestashop using the Prestashop import facility. It also has no resemblance to the old version.

 

Download is available on my website (no need to register, direct download available).

 

https://oavea.com

 

To use the module after install just navigate to the following:

"Advanced Parameters > Export Products"

 

Please note the downloads attached to this post are for older versions of prestashop. If you are on prestahsop 1.4 or below download the exportproducts_v1.0.zip file.

 

-----------------------------------------------------------------------------------------------------

 

Hello all,

I've created an easy to use product export module which is free to download and use.

Export Products v1.0

Features
* Choose what to export by dragging and dropping from available fields.
* Choose how you want the export ordered by easily sorting the selected fields.
* Save an export so you can load your chosen fields again later.
* Clean easy to use interface.
* Language Select.
* Delimiter option.

 

UPDATE v1.0
Updated to work with prestashop 1.4.

UPDATE v0.5:
Added EAN13
Changed the export to stream the file instead of saving to disk. Should fix file permission problems.

UPDATE v0.4:
Changed the export folder to the upload folder in the root of prestashop to avoid permission issues.

UPDATE v0.3:
Added support for prestashop 1.1.
Hopefully fixed permissions problems by creating a seperate directory for csv file on install.
Fixed reinstall issues by adding a DROP if exists before the tables are created on install.

Download: Export Productsv1.0

Please remember it should work for most versions of prestashop if not all. Also backup your database before doing any export/imports.

Attached Files


Edited by leemarkwood, 15 October 2014 - 08:44 AM.
0

http://oavea.com - Custom Modules & Themes


JAKCRABBIT

    PrestaShop Fanatic

  • Members
  • PipPipPipPip
  • 2653 posts

Posted 18 December 2009 - 11:28 AM

Wow, it look amazing, hurry i try it :)

ICQ: 275784332


leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 12:19 PM

Thanks, Let me know how you get on.

http://oavea.com - Custom Modules & Themes


gra

    PrestaShop Newbie

  • Members
  • Pip
  • 11 posts

Posted 18 December 2009 - 12:35 PM

Using ver 1.25. Installs OK, but getting the following error when clicking configure.

Table 'prestashop.ps_export_set' doesn't exist

SELECT * FROM `ps_export_set`


-- Graham
-- Graham (www.bestbooksforkids.com.au)

mohsart

    PrestaShop Addict

  • Members
  • PipPipPip
  • 749 posts

Posted 18 December 2009 - 12:36 PM

Great! :-)
However, some characters get garbled, eg the Swedish å, ä, and ö; I believe this can be sorted with utf8_decode() but don't see right away where to insert it...

/Mats
My blog about using PrestaShop
My shops: Spel (1.4.3) HandKraft (1.5.2)
I help for free, but you may donate a small sum via PayPal to shop@mohsart.se if you feel that I've been helpful

leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 12:39 PM

Ok, I'll have a look into your problem Graham.

Also, I hadn't thought about different character sets. I shall update asap.

http://oavea.com - Custom Modules & Themes


leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 12:48 PM

Graham,

I'd left out the set table's sql from the install sql file.

CREATE TABLE IF NOT EXISTS `ps_export_set` (  `id` int(10) unsigned NOT NULL auto_increment,  `set_name` varchar(200) NOT NULL,  `set_values` text NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;


Running the above sql in phpMyAdmin should do the trick. If you dont have access to phpMyAdmin pm me and i'll help you out.

http://oavea.com - Custom Modules & Themes


leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 12:54 PM

I've added utf8_decode() to the exportproducts.php file. Just download a new copy and upload the exportproducts.php file.

Could you let me know if thats fixed the character encoding issues :)

http://oavea.com - Custom Modules & Themes


mohsart

    PrestaShop Addict

  • Members
  • PipPipPip
  • 749 posts

Posted 18 December 2009 - 01:04 PM

Yes, works perfect now.
Great job :-)

/Mats
My blog about using PrestaShop
My shops: Spel (1.4.3) HandKraft (1.5.2)
I help for free, but you may donate a small sum via PayPal to shop@mohsart.se if you feel that I've been helpful

junnecito

    PrestaShop Fanatic

  • Moderators
  • 1595 posts

Posted 18 December 2009 - 01:07 PM

Hi Imwood:
Thanks for this nice module, will be posible to upload pics also?
Thanks again

gra

    PrestaShop Newbie

  • Members
  • Pip
  • 11 posts

Posted 18 December 2009 - 01:13 PM

Still having some issues. Getting to the configure page now but seeing:

Notice: Undefined index: export_data in D:\localhost\www\bestbooksforkids\modules\exportproducts\exportproducts.php on line 83

Should clarify that I am running a test site (locally using Wampserver), and I have had issues (resolved I hoped) with my database due to hung Prestashop upgrade in the past.

- Graham
-- Graham (www.bestbooksforkids.com.au)

leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 01:21 PM

Graham,

Thats just a notice to tell you that my coding isnt the best practice at that part in the script. I'll quickly ammend my sloppy code.

Cheers,
Lee.

http://oavea.com - Custom Modules & Themes


Jaap Visser

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 18 December 2009 - 01:26 PM

Still have this issue:

SELECT * FROM `ps_export_fields`

Please help me out :)

leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 01:26 PM

Updated once again, download a new copy and overwrite the files and you shouldn't see that error notice.

http://oavea.com - Custom Modules & Themes


Jaap Visser

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 18 December 2009 - 01:28 PM

Still the same problem: SELECT * FROM `ps_export_fields` :S

leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 01:28 PM

Jaap Visser,

Could you be more specific please. It's hard for me to know the exact cause. Its more than likely that the install has failed.

http://oavea.com - Custom Modules & Themes


Jaap Visser

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 18 December 2009 - 01:30 PM

I've download the new version...
Install it in the back office...
Try to run the module and get this screen notice:
-----------------------------------------------------------
Table 'prestashop.ps_export_fields' doesn't exist

SELECT * FROM `ps_export_fields`
-----------------------------------------------------------

leemarkwood

    PrestaShop Apprentice

  • Members
  • PipPip
  • 104 posts

Posted 18 December 2009 - 01:33 PM

If you have phpMyAdmin or another tool you can run an sql command in then please run the following code on your database.

CREATE TABLE IF NOT EXISTS `ps_export_fields` (    `id` int(10) NOT NULL auto_increment,    `field_name` varchar(50) NOT NULL,    `database_name` varchar(50) NOT NULL,    `category` varchar(50) NOT NULL,    `position` int(2) NOT NULL default '0',    PRIMARY KEY  (`id`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;        CREATE TABLE IF NOT EXISTS `ps_export_set` (  `id` int(10) unsigned NOT NULL auto_increment,  `set_name` varchar(200) NOT NULL,  `set_values` text NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;INSERT INTO `ps_export_fields` (`id`, `field_name`, `database_name`, `category`, `position`) VALUES(1, 'Product Id', 'id_product', 'products', 0),(2, 'Product Reference', 'reference', 'products', 0),(3, 'Name', 'name', 'products_lang', 0),(4, 'Short Description', 'description_short', 'products_lang', 0),(5, 'Long Description', 'description', 'products_lang', 0),(6, 'Quantity', 'quantity', 'products', 0),(7, 'Price', 'price', 'products', 0),(8, 'Wholesale Price', 'wholesale_price', 'products', 0),(9, 'Supplier Name', 'id_supplier', 'products', 0),(10, 'Manufacturer', 'id_manufacturer', 'products', 0),(11, 'Tax %', 'id_tax', 'products', 0),(12, 'Categories', 'id_category_default', 'products', 0),(13, 'On Sale', 'on_sale', 'products', 0),(14, 'Reduction Price', 'reduction_price', 'products', 0),(15, 'Reduction %', 'reduction_percent', 'products', 0),(16, 'Reduction From', 'reduction_from', 'products', 0),(17, 'Reduction To', 'reduction_to', 'products', 0),(18, 'Supplier Reference', 'supplier_reference', 'products', 0),(19, 'Weight', 'weight', 'products', 0),(20, 'Date Added', 'date_add', 'products', 0),(21, 'Active', 'active', 'products', 0),(22, 'Meta Title', 'meta_title', 'products_lang', 0),(23, 'Meta Description', 'meta_description', 'products_lang', 0),(24, 'Meta Keywords', 'meta_keywords', 'products_lang', 0),(25, 'Available Now', 'available_now', 'products_lang', 0),(26, 'Available Later', 'available_later', 'products_lang', 0),(27, 'Tags', 'tags', 'products', 0),(28, 'Accessories', 'accessories', 'products', 0);

http://oavea.com - Custom Modules & Themes


gra

    PrestaShop Newbie

  • Members
  • Pip
  • 11 posts

Posted 18 December 2009 - 01:35 PM

Getting further for me. No errors anymore. Can install / uninstall ok. Attached picture shows what I see. (Nothing to click?)

- Graham

Attached Files


-- Graham (www.bestbooksforkids.com.au)

Jaap Visser

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 18 December 2009 - 01:41 PM

Oke done the SQL thing, but now the same screen as GRA...





Also tagged with one or more of these keywords: export, products, free, module

3 user(s) are reading this topic

2 members, 1 guests, 0 anonymous users