How to

  • Posts: 377
  • Thank you received: 7
11 years 3 weeks ago #132894

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82967
  • Thank you received: 13393
  • MODERATOR
11 years 3 weeks ago #132974

Hi,

In the action, you shouldn't select "operation" but "integer".

Please Log in or Create an account to join the conversation.

  • Posts: 377
  • Thank you received: 7
11 years 3 weeks ago #133017

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 377
  • Thank you received: 7
11 years 3 weeks ago #133022

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?

Please Log in or Create an account to join the conversation.

  • Posts: 82967
  • Thank you received: 13393
  • MODERATOR
11 years 3 weeks ago #133092

Yes. By default, there is a filter limit of 500 elements.
If you have more elements, add a "limit" filter and increase the number of elements to be processed.

Please Log in or Create an account to join the conversation.

  • Posts: 377
  • Thank you received: 7
11 years 3 weeks ago #133109

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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82967
  • Thank you received: 13393
  • MODERATOR
11 years 3 weeks ago #133184

Hi,

Could you copy/paste the full query of the error so that we can analyze it ?

Please Log in or Create an account to join the conversation.

  • Posts: 377
  • Thank you received: 7
11 years 3 weeks ago #133229

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 3 weeks ago #133311

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.079 seconds
Powered by Kunena Forum