Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

port27374

Archived
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • Real Name
    port
  • Gender
    Male

port27374's Achievements

  1. Ok guys - just incase anyone else has this problem, i solved it by loading the site on to a local installation of XAMPP, then i could play around with the php.ini files myself, obviously the ISP had an overide on the EZ php config in the Cpanel. In the end the file had over 70,000 products in it and was a 176MB CSV file....
  2. Hi Folks, I have a site which is in a shared web hosting environment, it started of quiet small and has been modified quiet heavily with STS and add ons(still on V2.2 RC2a), however, with the combination of products and categories the site has grown to over 70,000 products. At some point in the near future i was thinking about moving this to a dedicated server as the site is quiet slow... however when i try to download a complete CSV file, my ISP server times out... with the following message: Fatal error: Out of memory (allocated 50593792) (tried to allocate 48760518 bytes) in /home/website/public_html/admin/easypopulate.php on line 2689 I have tried all the different ways listed on the EP backend interface, I can download partial files (for example product name/descrition etc...) but it doesnt correlate because the same product has been duplicated into the category structure dozens of times. so when i download the category file, it has many fields corresponding to one product. In effect i am trying to move the whole structure over. Including the products. Due to a previous server crash and a series of unfortunate circumstances at our company i am unable to retrieve the orignal EP files which were used to create these items in the first place. The other problem is, that some of th products in the database are now obsolete, so for example, i have one product which is compatible with about 1300 categories, to remove this manually is impossible, is their anyway of editing the database directly through phpmyadmin in which i can remove or add products like this? My EP settings are as follows: EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.28.9 HTTP: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 DB: MySQL 5.1.30 PHP: 5.2.9 (Zend: 2.2.0) Temp Directory: /home/website/public_html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 20 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false my question is, what is the easiest and quicket way of me retrieving my product data... and downloading or recompiling a complete CSV file. Is their a way to construct a query in phpmyadmin to extract all product info back to a CSV file with the same colum headings as the orignal EP file(s)? if so, how do i make it?:blink: I have tried on several occassions to obtain help from the ISP but they are unsure why there server is timing out like this, a bunch of dodo's as far as i am concerned, but unfortunately i have to put up with them, as we are on contract. I have something called PHP.ini EZ config in my cpanel and i have tried to increase mysql.connect.timeout, post_max-size, memory_limit etc... but to no avail, giving me the same error. As always your viewing and contrbuting is always appreciated...:rolleyes: Kind regards port
  3. Hi there - and thanks for the reply, appreciate your time, ill try removing the spaces in the category names as soon as i can in the morning, but i have checked the phpmyadmin for the Product model field and yes i have defintely changed it to a varchar(20) for product_model - it shouldnt be a problem for me to remove the spaces after the category names and try again will post back as soon as i have cleaned the data and re-imported with a good result (fingers crossed) best regards
  4. Hi again - sorry should have done this in the first place! Settings & Info EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.26.5-grsec HTTP: Apache/1.3.41 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8h DB: MySQL 5.0.51a-community PHP: 5.2.6 (Zend: 2.2.0) Temp Directory: /home/mobim8c/public_html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 20 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false im not recieving any error messages as such A sample of the file i am trying to upload can be found here http://www.mobim8.com/temp/1100-3110e.csv If i try to upload this file and import it into my database it will do some weird things. You can see how my site is structured at the following URL http://www.mobim8.com The category 1 is mobile accessories (Mobile Acc's) Category 2 is the Manufacturer of the phone (Nokia) Cat 3 is the model of the phone Nokia 1100, Nokia 1200 etc.... Cat 4 includes 14 different categories such as chargers, batteries,, handsfree kits etc... What im trying to do is insert one product into many different phone models, particularly in the "parts & Spares" section which is in Category 4. 1) If i select the "normal" import option it will duplicate the categories 1100 to 3110evol and create the same phone model with 1 sub category and then the product? but i thought EP wouldnt do that because it should know not to replace something which is already there? to see an example of this if you click here http://www.mobim8.com/mobile-accs-nokia-c-57_65.html you will see the first two categories are the same Nokia 1100, however when you click on each link you will notice the orignal one has 14 sub categories, but the new one which has been created by my most recent EP import has one sub category which has one new product.... 2) IF i select the "add new only" opttion before importing it for some reason only imports the FIRST product in the CSV file. and seems to ignore the rest of the items in there. At first i thought this was because my product model's are the same but then i was told that because EP is intelligent enough to know that its the same product in the different category, that wouldnt be a problem? i dont know if that is true So if anyon can help i'd be grateful, as by the end of this week i should have had many thousands of products online !! :huh: many thanks again
  5. Hi folks, has anyone ever added products to their catalog through direct insertion into the MySql database? is this possible? if so, which tables need to be altered and are there any additional steps required such as any additional coding in order to insert a large range of products and remove on demand.... many thanks
  6. Hi folks, Im using: OSC V2.2 RC2 EP V2.76g MS2 I was wonderin if anyone could help on a problem i am having with EP - i have been trying to get it going for a couple of days but something funny is going on - i have installed EP and everything seems to be working fine, i am trying to input the same product into different categories in my site... so obviously the product model is the same since it is the same product, the file is structurally sound as i have downloaded an exported file from EP and worke from that as a guide. For some reason when i upload a file regardless of how many products (have tried from 2 - 200 per file) (in this case instances of the same product but in different categories - denoted by different image names and category names) the system only imports the FIRST product, and it doesnt generate any errors. the EOREOR header is ok and inplace. Another weird issue was when i done this the first few times it duplicated all the categories and products that were already existing in the database (this was when i chose to use the "Normal" input option... what is the difference between "normal" "add new only" and "update only" option? I have excel safe mode turned to true and am importing files as CSV (MS-DOS) files. ALSO, has anyone used any products from here before http://conceptlaboratory.com/ or does anyone know of any other paid addons i can use to populate my store like the ones at concept labs? Your time is appreciated as always Best Regards
  7. Hi folks, Im using: OSC V2.2 RC2 EP V2.76g MS2 I was wonderin if anyone could help on a problem i am having with EP - i have been trying to get it going for a couple of days but something funny is going on - i have installed EP and everything seems to be working fine, i am trying to input the same product into different categories in my site... so obviously the product model is the same since it is the same product, the file is structurally sound as i have downloaded an exported file from EP and worke from that as a guide. For some reason when i upload a file regardless of how many products (have tried from 2 - 200 per file) (in this case instances of the same product but in different categories - denoted by different image names and category names) the system only imports the FIRST product, and it doesnt generate any errors. the EOREOR header is ok and inplace. Another weird issue was when i done this the first few times it duplicated all the categories and products that were already existing in the database (this was when i chose to use the "Normal" input option... what is the difference between "normal" "add new only" and "update only" option? I have excel safe mode turned to true and am importing files as CSV (MS-DOS) files. ALSO, has anyone used any products from here before http://conceptlaboratory.com/ or does anyone know of any other paid addons i can use to populate my store like the ones at concept labs? Your time is appreciated as always Best Regards
  8. Hi, could someone please explain briefly the difference between the import file options in the EP interface in admin panel "Normal" "Add new only" "Update only" i was trying to place a product into 188 sub categories, and ended up duplicating those subcategories each with 1 product in them??!?!? i was using the "add new only" option... many thanks :huh:
  9. Hey folks, I have just setup a new osc store, the task ahead seems daunting as we have over 3000 products to put in and many replications and links to set up - is there any free or commercial product which anyone is aware of which will take the 'ouch!' out of this painstaking task we have ahead? thankyou P.s. ive seen the EP addon but its still quiet involved and lengthy.. any other addons?
  10. Hey folks, I have just setup a new osc store, the task ahead seems daunting as we have over 3000 products to put in and many replications and links to set up - is there any free or commercial product which anyone is aware of which will take the 'ouch!' out of this painstaking task we have ahead? thankyou
  11. Randy, Why dont you just keep the images you need in a local directory on your PC, for example on your desktop, and just browse to the images as and when you need them, as far as i am aware, unless you have some specific modifications on your osc system, it will prompt you for a location to your local system only.
×
×
  • Create New...