AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Twobad on April 14, 2014, 01:36:56 PM

Title: Featured Products
Post by: Twobad on April 14, 2014, 01:36:56 PM

Hello

Which column in the CSV file relates to = Featured Product: MUST be "ON" for product to appear as featured in your store.

What i am trying to do is not have this feature on when uploading new products but once i have loaded those new products i can then just go into admin and select the products i want to be featured products?

So i only need to know the column in the CSV file where this setting relates to so i can turn it on or off.

Thanks

Title: Re: Featured Products
Post by: llegrand on April 14, 2014, 03:35:43 PM

it is located in the table called:   products_featured

There is only one field product ID

Lee

Title: Re: Featured Products
Post by: Twobad on April 14, 2014, 03:44:55 PM

Hello Lee

Thanks for the reply regarding this but it sound like your saying that this setting is not in the CSV file itself but in the backend settings of phpmyadmin, is this correct?

If not then can you point me to where this setting is in the CSV file as we cannot see it at all?

Thanks

Title: Re: Featured Products
Post by: llegrand on April 14, 2014, 05:23:22 PM

what csv file are you referring to?  where did you get your csv file?

Are you exporting from an exisitng cart using the system  > data  > export/import or something else?

If you will provide me the details of where you CSV originated  or what you are trying do to,  I can probably direct you to accomplishing your goal.  Your question is too generic to assist you properly.

Lee

Title: Re: Featured Products
Post by: Twobad on April 14, 2014, 06:28:22 PM

Hello Lee

The CSV file has been exported from AbanteCart backend admin panel of my site and this (products_featured) field is missing from the exported CSV file?

What i am trying to do is import a new CSV file with new products inside but i want to import those new products without this (products_featured) function turned on so later i can go in my admin panel and choose which products will be featured on home page.

Regards

Title: Re: Featured Products (possible bug - Admins pls help)
Post by: llegrand on April 15, 2014, 12:00:24 AM

Ok,  it's looks like there is a possible bug in the export routine.  I verified this on two different installations, both 1.1.8  but different domains.

Below is a list of the tables/fields that are exported in a complete Product export request.  There is no Product_featured table exported although there are products with the featured enabled.

Additionally,  if one requests just Products_featured export -  it fails.
Admins will have to fix this for the export.     BUT if there is no info in the export,  there will be not additions in your import for the product_featured switches, so you should be okay to proceed and not have any of the items switched on.


Lee

 

products.product_id

products.model

products.sku

products.location

products.quantity

products.stock_status_id

products.manufacturer_id

products.shipping

products.ship_individually

products.free_shipping

products.shipping_price

products.price

products.tax_class_id

products.date_available

products.weight

products.weight_class_id

products.length

products.width

products.height

products.length_class_id

products.status

products.date_added

products.date_modified

products.viewed

products.sort_order

products.subtract

products.minimum

products.maximum

products.cost

products.call_to_order

product_descriptions[0].language_id

product_descriptions[0].name

product_descriptions[0].meta_keywords

product_descriptions[0].meta_description

product_descriptions[0].description

products_to_categories[0].category_id

products_to_categories[1].category_id

products_to_categories[2].category_id

products_to_stores[0].store_id

Title: Re: Featured Products
Post by: Twobad on April 15, 2014, 06:38:51 AM

Hi Lee

Thanks for the info regarding this and nice work !!

Anyway every time i try to upload the products via the CSV file they still default to the featured home page settings and as of now there are 2 ways to turn this off and that's either to edit the item in admin or turn off the featured products block.

Thanks