Jump to content

VIXUS

Members
  • Posts

    436
  • Joined

  • Last visited

Everything posted by VIXUS

  1. One more question... can i upload attributes... periodicaly? Theres a bug so i can't use BO to upload attributes becouse Presta 1.1 simply duplicates them.
  2. Hi, importing attributes works as described but it has one nasty ERROR! It duplicates atributes with every new import. It dont reckognise attribute as allready existing but instead imports it as new one with unique ID. Does anyone have any solution to this?
  3. Same problem here! Did anyone find a way how to fix this?
  4. Sounds interesting... if i can update mine database with new products then this is module for me. PM me if you have some demo site to test it. Cheers!
  5. Huh... still some help needed. this line '.str_replace("&", "&", $row['quantity']).' works correct and returns exact number of products on stock. But i need to change quantity as number into word "AVAILABLE" when quantity number is more than 0. Can someone halp?
  6. OK, i'w found some examples on forum and i put together fully functional script so here it is if someone needs it. <?php $langHr = 7; include(dirname(__FILE__).'/config/config.inc.php'); require_once(dirname(__FILE__).'/init.php'); error_reporting(0); $p=Product::getProducts(7, 0, 0, 'id_product', 'desc', false); // number 7 is id of language in database $products=Product::getProductsProperties(7, $p); // number 7 is id of language in database header("Content-Type: text/xml"); echo '<?xml version="1.0" encoding="utf-8"?> '; foreach ($products as $row) { if ($row['active']){ $img=Product::getCover($row['id_product']); echo ' '.str_replace("&", "&", $row['id_product']).' '.str_replace("&", "&", $row['name']).' '.str_replace("&", "and", strip_tags($row['description_short'])).' '.($row['price']*1).' '.str_replace("&", "&", $row['quantity']).' '.str_replace("&", "&", $row['category']).' <link>http://www.site.com'.$row['link'].'</link> http://www.site.com/shop/'.$shopUrl.'img/p/'.$row['id_product'].'-'.$img['id_image'].'.jpg '; } } echo ''; ?> put this php file into your shop folder and thats it... just send that url to your partners and they are ready to receive your data.
  7. Thanx mate, this helped to reduce pricelist more than 50%... If someone know how to reduce multiple products, please help!
  8. Hello! I am working on php script that would enable mine partners to download my pricelist from certain link... It is based on this work: http://www.prestashop.com/forums/viewthread/25318/modules_tiers/module_dexport_catalogue_format_xml I got it working but but have some problems... script generates huge ammount of products becouse it inputs all existing products, active and non active and it create multiple entries of the same product becouse it is in multiple categories even do it is the same product with its unique product ID. (script is attached) Any help how to purge that data so that php dont generate xml with multiple product entries and dont collect inactive products? HELP! pricelist_xml_generator.php
  9. One question... does someone know how to export only active products into csv and not the whole database? and yeah... to make UTF-8 work... change ISO-8859-1 to cp1250 in exportproducts.php
  10. It could be done verry easy with smart usage of categories and subcategories and with specific features setting.
  11. nothing so far... i will order a custom rework of entire checkout process and that will be implemented aswell.
  12. @ ejectcore Module is not working with version 1.105?
  13. yes... that is the common problem... i dont import more than 20 products at the time. Use search to see how others managed to resolve that issue.
  14. Well i cant select existing features but i can only create new one that way.
  15. yes, and when you are importing set every column that is empty to "IGNORE" state
  16. basicly what is wrong with your csv is that you are providing only partial data and it misses all other data that it needs. open this file in your excell and you will see what is wrong with your file.... mine language signs might be messy but you will get the perspective. (i hope) Anyway use search becouse on this matter theres a ton of posts. sample.csv
  17. It is clear that you are doing something wrong. For test... try to import all products in all categories at once from a single file and they check if you perhaps use identical products ID's and so one overwrites other or you did not set correct category ID's so products move from one to oher category?
  18. if you want same product in more categories simply input all their ID's separated with comas eg. categories: 100,101,102 and product will be in all of them.
  19. for one thing ID can be only number this is sample of my product... it might give you some clues: 102100001;1;INTEL Celeron 430;102,100;252,032521;23;248,35;0;;;;;102100001;BX80557430;92;360;;;;10;1.80 GHz Clock Speed, 1 Core, 1 Thread, 800 MHz FSB Speed, 512 KB L2 cache, 35 W TDP, 64-bit, Socket LGA775, box - jamstvo 36 mj.;;;;;;RASPOLOŽIVO;U DOLASKU;http://www.h2-shop.com/images/produkti/ITL-BX80557430.jpg;;
  20. Can you please post sample for one product that has 2 or 3 features and that one feature has atleest 2 values. How to set that in my csv? I have extracted all my features codes and their values aswell from sql but i dont know how to correctly write them into features "column" in my csv? this is one sample product: 102100001;1;INTEL Celeron 430;102,100;252,032521;23;248,35;0;;;;;102100001;BX80557430;92;360;;;;10;1.80 GHz Clock Speed, 1 Core, 1 Thread, 800 MHz FSB Speed, 512 KB L2 cache, 35 W TDP, 64-bit, Socket LGA775, box - jamstvo 36 mj.;;;;;;RASPOLOŽIVO;U DOLASKU;http://www.h2-shop.com/images/produkti/ITL-BX80557430.jpg;; and now at the end i want to insert my features... eg: my feature called socket 1156 has ID 8 and value is 37... how to write that into csv for import? PS: i still use 1.105
×
×
  • Create New...

Important Information

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