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
it is located in the table called: products_featured
There is only one field product ID
Lee
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
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
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
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 |
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