Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easypopulate duping and placing items in wrong categories


videobus

Recommended Posts

I've finally got EP to work, but can't figure out why it's inserting each item 2x, first in the correct category, and second one into wrong product categories.

 

When I compared the import text file with the categories, it insert the first one in the correct category, and then the same item is inserted the second time in the wrong category using the one from item following it.

 

BTW the v_date_avail field is blank and the v_date_added is the date you see in the file.

 

Example:

 

1st insertion: .COM FOR MURDER Horror (correct category)

2nd insertion: .COM FOR MURDER Gamecube (dup and incorrect category, using the next item's category).

 

1st insertion: 007 (GAMECUBE) Gamecube (correct category)

2nd insertion: 007 (GAMECUBE) Xbox (dup and incorrect category, using the next item's category).

 

The website is www.mybroadwayvideo.info (not on line yet).

 

Here is a sample of the input file with the heading (I inserted cr/lf after each record to make it easier to read for this post):

 

v_products_model v_products_name_1 v_products_price v_date_avail v_date_added v_products_quantity v_categories_name_1 v_tax_class_title v_status EOREOR

 

472690 .COM FOR MURDER 0.00 2004-10-01 1 Horror Taxable Goods Active EOREOR

 

462579 007 (GAMECUBE) 0.00 2004-02-23 1 Gamecube Taxable Goods Active EOREOR

 

511973 007 AGENT UNDER FIRE 0.00 2006-03-08 2 XBox Taxable Goods Active EOREOR

 

453996 007 AGENT UNDER FIRE (PS-2) 0.00 2006-03-10 1 Playstation 2 Taxable Goods Active EOREOR

 

324102 007 AGENT UNDER FIRE (PS2-INST 0.00 2006-03-10 1 Playstation 2 Taxable Goods Active EOREOR

 

459863 007 AGENT UNDER FIRE (XB) 0.00 2006-03-07 1 XBox Taxable Goods Active EOREOR

 

502313 007 AGENT UNDER FIRE INST. 0.00 2001-11-27 1 Playstation 2 Taxable Goods Active EOREOR

 

516151 007 AGENT UNDER FIRE(XB-INSTR) 0.00 2006-03-07 1 XBox Taxable Goods Active EOREOR

 

517548 007 INST. (GAMECUBE) 0.00 2004-02-23 1 Gamecube Taxable Goods Active EOREOR

 

459808 007 NIGHTFIRE (GC) 0.00 2006-03-24 1 Gamecube Taxable Goods Active EOREOR

 

 

I know I'm asking for a lot, but I'm under a tight timetable to get this working. Any help/suggestions/hints will be greatly appreciated.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...