Database questions

[Guest]

I am using OSC snapshop from 3/5/03.

 

I also have 'EasyPopulate' installed for adding products.

 

When I FTP my first 30 items it works fine.

 

When I want to add a new listing of 50 items, the original items are still there.

 

I have to go to 'PHP MyAdmin' it seems and delete them manually.

 

Why does this happen?

 

I DL the text file.....put new items in it and UL it.

 

Is there an easier way to delete items from the SQL DB?

 

There are no check boxes it seems....just 'Edit' or 'Delete' links.

 

Thanks!!

[Guest]

When I FTP my first 30 items it works fine. 



When I want to add a new listing of 50 items, the original items are still there.

 

 

This is expected behavior. If you download the EP file after you upload stuff to your catalog the records come down just in case you want to edit them. it is perfectly allright to leave the records in the EP file, however just remember to split it if you have more than 300 records before you import it.

 

 

HTH, Tony

[Guest]

How would I delete the unwanted items?

 

Instead of having the 50 items, I have 50 plus the original 30 items in the catalog.

 

When I UL the new text file, I have deleted the old 30 items from this text file.

 

Shouldnt the catalog listing only reflect the most current text file UL'd?

[Guest]

How would I delete the unwanted items?  

 

Instead of having the 50 items, I have 50 plus the original 30 items in the catalog.  

There are a few ways you can do this, but not with easy populate. Easy Populate will allow you to set the item inactive where it doesn't show up, but it remains in the database.

 

To remove it completely you would have to delete it through the admin or from the database itself with myphpadmin.

 

HTH, Tony

[Guest]

Please explain:

 

How to UL the text file so that the extra items are not seen in the catalog.

 

 

How to easily delete the items in PHP MyAdmin.

 

If I have to delete 50+ items...I have to click on the 'delete' link, this takes awhile!

 

Is there the option to check a checkbox and delete all 50 at once?

[Guest]

To set the items to inactive, change the status column from active to inactive. This effectively is changing the status from green to red like you would in the admin.

 

In PHPMyAdmin you need to be very careful as you are dealing with the database. I would backup the databse with cpanel before making any changes. it is very easy to mess things up even if you are a pro. I would probably just delete them one by one from admin.

 

hth, tony