Adding Promo Text Field Via Csv

Hi,



There are promo text field in product edit page. I have uploaded my entire product collection via CSV. There is no variable in available in csv to pass the promo text.



Can any one suggest how to apply this promo text via csv.





I tried digging in to many import file but nothing worked.



let me know guys… Need a expert hand.





RR

I think CS-Cart forgot about this one. You should be able to update many products at once using “Edit Selected” from the dropdown when you are in the products catalog, but the promo text is missing.

i know i know… I saw that…

Nothing new about this subject? A way to modify promo text to all products?

[quote name='ravt' timestamp='1394094749' post='178851']

let me know guys… Need a expert hand.

[/quote]



[color=#282828][font=arial, verdana, tahoma, sans-serif]Please create the “[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file with the following content:[/font][/color]


```php

$schema['export_fields']['Promo text'] = array (
'table' => 'product_descriptions',
'db_field' => 'promo_text',
'multilang' => true,
);
return $schema;
```

Then clear the cache and check the result. Thanks.

@ecomlabs thanks again for your time and sharing your knowledge.



So after we post this code can we Import the pormo text via csv.



I will try once if so, It will save lot of time now.



thanks again

You are welcome!


[quote name='ravt' timestamp='1396498039' post='180816']

So after we post this code can we Import the pormo text via csv.

[/quote]



Yes, if 4.1.x version is used. Do not forget to clear the cache and make sure that the “My changes” add-on is enabled.

How can i delete promo text to all products? I have around 900 products with promo text.



I wanted a way to add promo text to some category products…but now i want to delete promo text from all prodcuts.



Thanks.

[quote name='lohanc' timestamp='1397220772' post='181550']

How can i delete promo text to all products? I have around 900 products with promo text.



I wanted a way to add promo text to some category products…but now i want to delete promo text from all prodcuts.



Thanks.

[/quote]



You can create .csv file with two columns only: “Product code” and “Promo text” (empty value). Then import it.



As alternative, you can go to phpMyAdmin and run the following query:



UPDATE cscart_product_descriptions SET promo_text = '';




Thanks.

[quote name='eComLabs' timestamp='1396434194' post='180742']

[color=#282828][font=arial, verdana, tahoma, sans-serif]Please create the “[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file with the following content:[/font][/color]


```php

$schema['export_fields']['Promo text'] = array (
'table' => 'product_descriptions',
'db_field' => 'promo_text',
'multilang' => true,
);
return $schema;
```

Then clear the cache and check the result. Thanks.
[/quote]

WORKS!

I'm trying to export my products but all i get is text like this:



[jï ÔßíìînŒÝN¯‹!êV?»aØêÒaai«ÛeP·»W} >ÃÓ/›1<¿Ôâ(59Gc–¥f磢g*þ=õyÍ¥&!ÛQ/âK•Gcäµ



I have tried several Times but to no avail.

I'm using the latest version.



Please can somebody advise, I have tried clearing the cache.

trying to open up into excel 2010

[quote name='eComLabs' timestamp='1396434194' post='180742']

[color=#282828][font=arial, verdana, tahoma, sans-serif]Please create the “[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file with the following content:[/font][/color]


```php

$schema['export_fields']['Promo text'] = array (
'table' => 'product_descriptions',
'db_field' => 'promo_text',
'multilang' => true,
);
return $schema;
```

Then clear the cache and check the result. Thanks.
[/quote]

Using 4.1.5 and even with clearing cache and activating the addon, the text still doesn't populate on my test product. Are there any other tips?

Thanks.

[quote name='hardwarehabitat' timestamp='1407268657' post='188884']

Using 4.1.5 and even with clearing cache and activating the addon, the text still doesn't populate on my test product. Are there any other tips?



Thanks.

[/quote]



It works for us. Please make sure that the My changes add-on is installed and activated

would be great if cscart include “promo text” in bulk edit in the new releases / upgrades.

[quote name='eComLabs' timestamp='1396434194' post='180742']

[color=#282828][font=arial, verdana, tahoma, sans-serif]Please create the “[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file with the following content:[/font][/color]


```php

$schema['export_fields']['Promo text'] = array (
'table' => 'product_descriptions',
'db_field' => 'promo_text',
'multilang' => true,
);
return $schema;
```

Then clear the cache and check the result. Thanks.
[/quote]


That did not work for me. Am i doing anything wrong?

Works on 4.2 for me



Thank you!

[quote name='robertparacay' timestamp='1418251785' post='199404']

Works on 4.2 for me



Thank you!

[/quote]



You are welcome!

[quote name='eComLabs' timestamp='1396434194' post='180742']

[color=#282828][font=arial, verdana, tahoma, sans-serif]Please create the “[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file with the following content:[/font][/color]


```php

$schema['export_fields']['Promo text'] = array (
'table' => 'product_descriptions',
'db_field' => 'promo_text',
'multilang' => true,
);
return $schema;
```

Then clear the cache and check the result. Thanks.
[/quote]

Works for me also

Thanks again

Hi, can someone tell me how or where to create:



“[color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file[/font][/color]



I activated the My Change add on

[quote name='Mr. G' timestamp='1421946600' post='203213']

Hi, can someone tell me how or where to create:



“[color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim/products.post.php” file[/font][/color]



I activated the My Change add on

[/quote]

PAste the code into a text editor and save as products.post.php

then upload that file to the folder via ftp on your server to the folder path below

[color=#282828][font=arial, verdana, tahoma, sans-serif]app/addons/my_changes/schemas/exim[/font][/color]