How to

Hi, I need to run a mass action to set where the product value = 0.00 then its publishing state needs to be set to unpublished. I have tried a few combinations however i cannot seem to get this to work, would you mind pointing me in the right direction? I have done the following so far (attached).

Thanks

Alex

Hi Nicolas,

I changed this to INT however I can still see products with a value of £0.00 published.
tradeheatingspares.com/Halstead-Boiler-P...-parts/5506-40h.html
I would just sort by the price on the backend and unpublish manually however i cannot sort by price on the backend?

Thanks

Alex

On that note, some of them have been changed to unpublished, but not all of them, do you think this is because there are so many products?

Thanks i have approx 13,000 products so i set the limit to 15,000 to cover for future additions however now i get an sql error please see attached.

Hi Nicolas,

This is the error:

An error has occurred.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET hk_product.product_published = 0 WHERE hk_product.product_id IN (5801,5800,5' at line 1 SQL=UPDATE dkibz_hikashop_product AS hk_product SET hk_product.product_published = 0 WHERE hk_product.product_id IN (1227,1283,1360,1355,1350,1348,1347,1342,1338,1335,1332,1326,1323,1418,1417,1416,1415,1413,1408,1407,1405,1393,1389,1387,1436,1428,1424,1483,1480,1543,1539,1530,1527,1610,1608,1591,1581,1659,1640,1639,1627,1685,1682,1678,1757,1755,1752,1742,1795,1794,1783,1772,1936,2384,8410,8452,7804,6022,6023,6024,6025,7776,3242,3220,3213,3293,3292,3291,3282,3265,3327,3310,3410,3409,3406,3400,3394,3387,3384,3436,3428,3482,3478,3477,3472,3471,3541,3535,3532,3531,3597,3590,3576,3575,3568,3646,3639,3637,3628,3627,3702,3680,3679,3666,3748,3747,3745,3781,3780,3779,3777,3769,3842,3841,3834,3832,3831,3829,3825,3901,3900,3899,3898,3896,3894,3893,3889,3888,3887,3886,3885,3884,3881,3880,3877,3876,3872,3871,3866,3959,3956,3954,3950,3949,3948,3947,3945,3944,3940,3938,3937,3930,3979,3976,3974,3971,3970,3969,3967,3966,3965,4045,4039,4038,4032,4031,4030,4028,4067,4104,4086,4085,4084,4083,4082,4079,4155,4152,4151,4149,4148,4144,4143,4215,4214,4213,4212,4209,4185,4182,4264,4262,4260,4258,4256,4253,4252,4248,4247,4242,4237,4236,4235,4287,4284,4283,4281,4280,4279,4278,4354,4353,4350,4348,4347,4346,4345,4343,4335,4334,4333,4332,4330,4396,4392,4391,4385,4384,4383,4381,4438,4432,4471,4530,4525,4506,4505,4577,4563,5590,4609,4595,9551,9552,9553,4662,9554,9555,4740,4739,4738,4737,4734,4733,4732,4731,4730,4729,4728,4722,4779,4778,4777,4776,4775,4774,4773,4772,4771,4770,4768,4767,4766,4765,4764,4762,4761,4760,4758,4756,4755,4754,4751,4750,4747,4745,4839,4836,4832,5539,4828,4827,4826,4823,5541,4807,4805,4804,4803,4801,4800,4799,4798,4797,4796,4795,4881,4876,4873,4848,4907,4905,4901,4900,4899,4898,5006,5078,5077,5076,5075,5074,5073,5072,5071,5067,5066,5065,5064,5063,5062,5061,5055,5053,5048,5047,5045,5126,5125,5124,5123,5122,5121,5120,5119,5118,5117,5116,5114,5113,5112,5111,5110,5109,5108,5107,5106,5105,5104,5103,5102,5101,5100,5099,5098,5097,5180,5179,5178,5177,5175,5174,5173,5172,5171,5170,5169,5168,5167,5166,5165,5164,5163,5162,5161,5160,5159,5158,5157,5156,5155,5154,9615,9616,9617,5209,5204,5197,5332,6017,5310,5302,5296,5350,5414,5410,5404,5402,5396,5538,5523,5521,5519,5518,5515,5514,5513,5512,5511,5574,5573,5572,5571,5570,5569,5568,5567,5566,5565,5564,5563,5562,5561,5560,5558,5557,5556,5555,5554,5553,5550,5549,5548,5547,5546,5622,5621,5620,5618,5617,5616,5615,5614,5613,9186,5606,5605,5604,5603,5602,5601,5600,5599,5598,5597,5596,5595,5652,5651,5650,5646,5645,5722,5716,9758,5703,9452,5785,9470,5782,9471,5780,9472,5778,9453,9473,5772,5767,9415,5736,5755,5774,5747,5795,5808,5806,5805,5804,5803,5802)SET hk_product.product_published = 0 WHERE hk_product.product_id IN (5801,5800,5799,5798,5878,5877,5876,5875,5874,5873,5858,5870,5869,5868,5867,5866,5865,5864,5863,5862,5861,5860,5859,5871,5857,5856,5872,5854,5853,5852,5851,5850,5849,5917,5916,5915,5914,5913,5912,5911,5910,5909,5908,5907,5906,5905,5904,5902,5901,5900,5899,5898,5963,5948,6014,6012,6011,6009,6007,6006,6005,6003,6000,5999,6055,6054,7801,6052,6051,6050,6049,6048,6047,6046,7800,6043,6042,6041,6040,6039,6038,6037,6036,6099,6098,6097,6096,6095,6094,6093,6092,6090,6089,6088,6085,6148,6145,6139,6137,6136,6135,6208,6186,6249,6248,6247,6246,6245,6244,6243,6242,6241,6240,6239,6236,6235,6313,6312,6311,6310,6309,6308,6307,6306,6303,6302,6301,6300,6299,6298,6297,6296,6295,6294,6293,6292,6291,6290,6289,6287,6286,6285,6339,6338,6337,6336,6335,6368,6471,6545,6538,6536,6532,6524,6519,6516,6633,6632,6626,6625,6624,6699,6698,6697,6690,6689,6688,6687,6683,6682,6675,6674,6672,6671,6670,6669,6666,6735,6733,6729,6726,6725,6724,6723,6720,6719,6717,6715,6794,6793,6791,6788,6787,6786,6784,6783,6782,6781,6779,6777,6776,6774,6773,6772,6771,6770,6767,6833,6831,6829,6828,6827,6826,6825,6824,6822,6821,6818,6816,6950,6938,6967,7006,7002,6992,6985,6984,6980,7038,7037,7035,7034,7032,7031,7029,7023,7021,7020,7019,7018,7015,7098,7097,7091,7090,7078,7077,7075,7074,7072,7137,7215,7327,7325,7324,7321,7320,7378,7374,7373,7372,7370,7369,7368,7367,7366,7365,7451,7449,7448,7446,7445,7437,7436,7434,7430,7427,7426,7424,7419,7417,7416,7495,7492,7490,7489,7486,7484,7482,7479,7478,7474,7472,7471,7469,7468,7467,7466,7556,7554,7550,7549,7548,7546,7543,7538,7537,7536,7534,7532,7531,7529,7518,7517,7516,7515,7598,7597,7596,7595,7594,7593,7592,7591,7590,7586,7585,7584,7583,7581,7579,7578,7577,7575,7574,7573,7571,7570,7569,7568,7567,7566,7639,7638,7637,7636,7635,7631,7630,7629,7628,7626,7625,7623,7619,7618,7616,7615,8519,7747,7753,7754,7755,7756,7805,7807,7808,7809,7810,7811,7815,7816,7817,7818,7819,7820,7803,7802,7822,7940,7986,7821,8450,8449,8409,8408,8407,8650,8651,8658,8714,8707,8704,8703,8701,8696,8691,8686,8685,8678,8677,8766,8763,8761,8759,8739,8737,8730,8808,8806,8803,8800,8797,8790,8780,8777,8776,8844,8842,8836,8832,9183,9181,9180,9178,9177,9176,9210,9209,9206,9205,9204,9203,9201,9199,9198,9197,9196,9195,5638,5636,5634,5587,9254,9253,9247,9244,9239,9237,9233,9232,9315,9314,9313,9310,9309,9308,9306,9305,9298,9293,9291,9289,9284,9356,9354,9350,9349,9346,9343,9341,9340,9339,9337,9336,9335,9333,9414,9412,9411,9409,9408,9407,9405,9402,9400,9396,9391,9387,9386,9385,9384,9383,9382,9381,9449,9448,9445,9442,9441)

Return to Control Panel

---

I also have another error when i try to run this mass action (attached)

This is the error for that one, i do not know if they are related or not. This is something that Xavier did resolve however when i updated hikashop it broke again and i dont have the file he uploaded so i might have to get that from a backup.

Error
An error has occurred.

1054 Unknown column 'hk_product.price_value' in 'field list' SQL=UPDATE dkibz_hikashop_product AS hk_product LEFT JOIN dkibz_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id SET hk_product.price_value = 0 WHERE hk_product.product_id IN (5798,5799,5800,5801,5802,5803,5804,5805,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5798,5799,5800,5801,5802,5803,5804,5805,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5798,5799,5800,5801,5802,5803,5804,5805,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5798,5799,5800,5801,5802,5803,5804,5805,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5798,5799,5800,5801,5802,5803,5804,5805,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5799,5800,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5799,5800,5848,5849,5850,5851,5852,5854,5855,5856,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5799,5800,5848,5849,5850,5851,5852,5854,5855,5856,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5870,5871,5800,5852,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,5800,5852,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,5800,5852,5872,5873,5874,5875,5880,5882,5884,5885,5886,5887,5888,5889,5890,5891,5800,5852,5872,5873,5874,5875,5880,5882,5884,5885,5886,5887,5888,5889,5890,5891,5800,5852,5858,5859,5861,5862,5920,5921,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5800,5852,5858,5859,5861,5862,5920,5921,5922,5923,5925,5926,5928,5929,5930,5931,5932,5933,5934,5935,5800,5852,5857,5858,5859,5861,5862,5921,5922,5926,5929,5930,5931,5932,5933,5936,5937,5938,5800,5852,5858,5859,5861,5862,5888,5921,5922,5926,5929,5930,5931,5932,5933,5936,5938,5939,5800,5852,5873,5874,5875,5880,5882,5884,5885,5887,5891,5989,5990,5991,5992,5800,5852,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,6350,6351,6352,5800,5848,5852,5855,5856,5857,5859,5861,5862,5864,5866,5867,5869,5871,6353,6354,6355,6356,5800,5852,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,6350,6351,6352,5800,5848,5852,5855,5856,5857,5859,5861,5862,5864,5866,5867,5869,5871,6353,6354,6355,6356,5803,6223,6226,6232,6234,6235,6239,6241,6242,6243,6244,6245,6246,6247,6248,6249,5803,6223,6226,6232,6234,6235,6239,6241,6242,6243,6244,6245,6246,6247,6248,6249,5804,6040,6041,6042,6043,6046,6047,6048,6049,6050,6051,6052,6054,6055,6056,6058,6059,6060,6061,6062,12431,5804,5873,6040,6041,6042,6050,6051,6052,6059,6060,6061,6063,6064,6065,6067,5804,5873,6040,6041,6042,6050,6051,6052,6059,6060,6061,6063,6064,6065,6067,5804,5873,6041,6042,6050,6051,6052,6059,6060,6061,6063,6070,6072,5804,5873,6041,6042,6050,6051,6052,6059,6060,6061,6062,6063,6070,6072)

Return to Control Panel

Thanks

Alex

Hi,

Thanks to read that post:
www.hikashop.com/forum/mass-actions/8611...rcentage.html#133308

Many errors have been corrected regarding this issue, thanks to try this new function.