Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by leemarkwood

  1. Well, I did have plans to make the export and import module. So im sure I can accommodate more than the standard import allows. e.g. updating products, category names, etc. We will see.
  2. Updated. Price should now be displayed as it would on a shop page using the default currency. I'll add an option to turn this feature off as I'm sure not everyone will want it.
  3. Yes you are correct, I didn't update the title column. I'll do that now As for the meta description, etc. I'll have a look.
  4. I'll rework the module tomorrow to allow you to choose a delimiter and a language.
  5. Mohsart, do you have all your fields with "ps_" at the start ? if so the tables to drop would be "ps_export_fields" and "ps_export_set". I'll add support to allow the user to choose which language they wish to export with soon. Maxhome, Not sure what your problem is... when did you download the module? do you have the latest copy?
  6. Mohsart, If you have phpmyadmin or some similar tools. Drop export_fields and export_set from your db then go into the modules table and remove the row that relates to the export module, it should be at the bottom of the table. Once you have done the above just hit install again on the modules page.
  7. Ok, The module has been updated to include image urls and names instead of id's for manufacturers and categories. Please uninstall and reinstall the module after updating all the files from the new download. Cheers, Lee.
  8. I'm glad you like it. I'll take all your comments and ideas into consideration. Keep them coming Cheers, Lee.
  9. Graham, The module has been updated again. Please check the export now works correctly.
  10. Graham, Module has been updated. Please get a new copy. Thanks, Lee.
  11. I can probably include the links to the images for each product. We will see.
  12. Ok, the Zip file has been updated. Please download it and then upload exportproducts.php and exportproducts.tpl If nothing changes straight away, make sure to clear your cache by deleteing the following file (Tools/Smarty/Compile/%%XX^XXX^XXXXXXXX%%exportproducts.tpl.php)
  13. Kwonga, I'm going to rewrite the install part of the script as many people are having problems with it. Hang tight. To get up and running now, please run the sql code above once again but replace "ps_export_fields" with "export_fields" and "ps_export_set" with "export_set". Jaap Visser, I'll have another version up as soon as the paths are no longer relative.
  14. Its due to the module using relative links. I take it both of you are using prestashop under a directory such as http://www.example.com/prestashop/'>http://www.example.com/prestashop/ instead of http://www.example.com/ ?
  15. 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);
  16. 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.
  17. Updated once again, download a new copy and overwrite the files and you shouldn't see that error notice.
  18. 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.
  19. 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
  20. 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.
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More