Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Adding Promo Text Field Via Csv Rate Topic   - - - - -

 
  • ravt
  • Junior Member
  • Members
  • Join Date: 11-Aug 10
  • 195 posts

Posted 06 March 2014 - 08:32 AM #1

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
After all its simple

 
  • Onkel_Sid
  • Junior Member
  • Members
  • Join Date: 04-Sep 10
  • 301 posts

Posted 06 March 2014 - 12:32 PM #2

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.

Stop smoking start vaping: Dampskyen.no


 
  • ravt
  • Junior Member
  • Members
  • Join Date: 11-Aug 10
  • 195 posts

Posted 07 March 2014 - 02:40 AM #3

i know i know.. I saw that..
After all its simple

 
  • lohanc
  • Junior Member
  • Members
  • Join Date: 07-Sep 07
  • 47 posts

Posted 02 April 2014 - 09:49 AM #4

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

www.piscina-ta.ro


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20793 posts

Posted 02 April 2014 - 10:23 AM #5

let me know guys.. Need a expert hand.


Please create the "app/addons/my_changes/schemas/exim/products.post.php" file with the following content:

<?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.
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • ravt
  • Junior Member
  • Members
  • Join Date: 11-Aug 10
  • 195 posts

Posted 03 April 2014 - 04:07 AM #6

@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
After all its simple

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20793 posts

Posted 03 April 2014 - 07:08 AM #7

You are welcome!

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


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.
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • lohanc
  • Junior Member
  • Members
  • Join Date: 07-Sep 07
  • 47 posts

Posted 11 April 2014 - 12:52 PM #8

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.

www.piscina-ta.ro


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20793 posts

Posted 14 April 2014 - 07:24 AM #9

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.


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.
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • ibizo
  • Member
  • Authorized Reseller
  • Join Date: 10-Jul 12
  • 39 posts

Posted 15 April 2014 - 06:37 PM #10

Please create the "app/addons/my_changes/schemas/exim/products.post.php" file with the following content:

<?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.


WORKS!

 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 20 April 2014 - 05:16 PM #11

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

[jï ÔßíìînŒÝN¯‹!êV?»aØêÒaai«ÛP·»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

 

Posted 05 August 2014 - 07:57 PM #12

Please create the "app/addons/my_changes/schemas/exim/products.post.php" file with the following content:

<?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.


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.

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20793 posts

Posted 06 August 2014 - 07:44 AM #13

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.


It works for us. Please make sure that the My changes add-on is installed and activated
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Rafass
  • Senior Member
  • Members
  • Join Date: 16-Jan 14
  • 304 posts

Posted 13 September 2014 - 08:55 AM #14

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

 
  • ambush510
  • Advanced Member
  • Trial users
  • Join Date: 20-Sep 14
  • 73 posts

Posted 29 September 2014 - 02:27 AM #15

Please create the "app/addons/my_changes/schemas/exim/products.post.php" file with the following content:

<?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.



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

 
  • robertparacay
  • Advanced Member
  • Members
  • Join Date: 14-Nov 11
  • 116 posts

Posted 10 December 2014 - 10:49 PM #16

Works on 4.2 for me

Thank you!

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20793 posts

Posted 11 December 2014 - 08:46 AM #17

Works on 4.2 for me

Thank you!


You are welcome!
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • victorb
  • Senior Member
  • Members
  • Join Date: 29-Oct 12
  • 183 posts

Posted 19 December 2014 - 05:49 PM #18

Please create the "app/addons/my_changes/schemas/exim/products.post.php" file with the following content:

<?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.


Works for me also

Thanks again

 
  • Mr. G
  • Member
  • Members
  • Join Date: 10-Dec 14
  • 34 posts

Posted 22 January 2015 - 05:10 PM #19

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

"app/addons/my_changes/schemas/exim/products.post.php" file

I activated the My Change add on

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4798 posts

Posted 22 January 2015 - 05:38 PM #20

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

"app/addons/my_changes/schemas/exim/products.post.php" file

I activated the My Change add on

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
app/addons/my_changes/schemas/exim

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2