Losing Manufacturers

[Kassie]

Ok this may sound a little wacky ... I have a rather large store and it has just begun. I will end up with close to 100,000 products. I was adding manufacturers today .. and all of a sudden .. all my A's and B's manufacturers were gone. Is there a limit, and if so can it be changed? I initially thought that they were just not showing up, but I went to the database, and looked through it .. and they are definately gone. It seems that now that they are gone .. other manufacturers were just randomly dropped into the product listings.

 

I really need help with this .. as I don't dare enter any more products .. as it is it seems that I am going to have to edit close to 1500 products.

 

Any help would be greatly appreciated!

[Jeremy at oddly enough]

How are you entering all the data? Can you tell if recent entries have overwritten older ones (did you take note of an id tags in the database for information, such as product_ids or such?) Sounds like there's definitely a problem as it goes to the database. With that much, you'd be best running scripts of SQL commands to update the tables directly with the data.

 

Jeremy

[Kassie]

Ok this may sound a little wacky ... I have a rather large store and it has just begun.  I will end up with close to 100,000 products.  I was adding manufacturers today .. and all of a sudden .. all my A's and B's manufacturers were gone.  Is there a limit, and if so can it be changed?  I initially thought that they were just not showing up, but I went to the database, and looked through it .. and they are definately gone.  It seems that now that they are gone .. other manufacturers were just randomly dropped into the product listings. 

 

I really need help with this .. as I don't dare enter any more products .. as it is it seems that I am going to have to edit close to 1500 products.

 

Any help would be greatly appreciated!

<{POST_SNAPBACK}>

 

This has always worked .. until I reached about 150 different manufacturers, and now I am well above that yet the database only shows 154 ..

 

I always insert from the manufacturers list.

 

Ok here is what I do when inserting product.

 

If it's from the same supplier .. and this is when it all happened,

 

I make a copy to and duplicate file.

then I change the manufacturer, item title, costs, description,quantity, model number, picture, and weight. I then preview, all looks good and do an insert.

 

If the supplier is not already in database, I click manufacturer and do an insert .. type the name, and then use back button back to product, the manufacturer is there and I click it and go onward with the rest of the steps for product info as I outlined above.

 

I went to the database .. and when I did a look into the manufacturers name table .. it shoots out 150 results .. it gives the next available auto index number as 175 ... but as I went through the list .. there are a bunch of missing numbers .. they are not all consecutive anymore. I understand that they are alphabetical .. but I meant that not all numbers from 1 to 175 are there .. there are gaps .. and I have not deleted any.

 

It seems that for every one that I insert now .. one is deleted. In the Manufacturers model .. it says showing 1 or 154.

 

None of the numbers seems to jive.

 

I am pretty good at manipulating files, etc for adding contribs, pretty advanced in html .. and almost functional in php .. have played with mysqul .. but I am by no means a pro .. and I went through this all methologically and nothing seems to jump out at me.

 

Am I missing something?

[Kassie]

How are you entering all the data?  Can you tell if recent entries have overwritten older ones (did you take note of an id tags in the database for information, such as product_ids or such?) Sounds like there's definitely a problem as it goes to the database.  With that much, you'd be best running scripts of SQL commands to update the tables directly with the data.

 

Jeremy

<{POST_SNAPBACK}>

 

This has always worked .. until I reached about 150 different manufacturers, and now I am well above that yet the database only shows 154 ..

 

I always insert from the manufacturers list.

 

Ok here is what I do when inserting product.

 

If it's from the same supplier .. and this is when it all happened,

 

I make a copy to and duplicate file.

then I change the manufacturer, item title, costs, description,quantity, model number, picture, and weight. I then preview, all looks good and do an insert.

 

If the supplier is not already in database, I click manufacturer and do an insert .. type the name, and then use back button back to product, the manufacturer is there and I click it and go onward with the rest of the steps for product info as I outlined above.

 

I went to the database .. and when I did a look into the manufacturers name table .. it shoots out 150 results .. it gives the next available auto index number as 175 ... but as I went through the list .. there are a bunch of missing numbers .. they are not all consecutive anymore. I understand that they are alphabetical .. but I meant that not all numbers from 1 to 175 are there .. there are gaps .. and I have not deleted any.

 

It seems that for every one that I insert now .. one is deleted. In the Manufacturers model .. it says showing 1 or 154.

 

None of the numbers seems to jive.

 

I am pretty good at manipulating files, etc for adding contribs, pretty advanced in html .. and almost functional in php .. have played with mysqul .. but I am by no means a pro .. and I went through this all methologically and nothing seems to jump out at me.

 

Am I missing something?

[Jeremy at oddly enough]

I suppose its possible in the copying and editing, one or more identifier numbers (as far as the db is concerned) are not getting changed, though you say this has not been a problem in the past. I would try running a mysql command to update the database directly.

 

The syntax is :

 

INSERT into tablename (field x, field y, field z, etc) VALUES (x,y,z, etc);

 

If the VALUE is text then it needs to be inside single quotes, eg. 'x'.

 

There are a couple of tables that need to be modified in order to have a product show up on the site, more if there are attributes. I find it handy to have a reference page nearby with the tables and their fields, and sometimes lists of related id numbers (such as product_id or manufacturer_id) handy for remembering all the details. If I'm doing big batches of information, I'll use excel to write the scripts I'll need.

 

It takes a bit to learn exactly what to do, but once you get it, this really blows the admin interface right out of the water as far as getting data entered! It can save weeks of tedious work!

 

Jeremy