Import/Export tool 1.5.1.1 reward points

Can I import the reward points that a customer gets when purchasing a certain product?

I can find the field for ´price in reward points´, but not the other one?

This would save quite a bit of time, and I did request this on another thread (I think). Thinking about this it could be quite difficult to do, as I have 4 reward groups. Someone else might have 2, you might have 5? Hopefully there is a way, because I am 1/3rd of the way through 1000+ products.

Inserted the points by Phpmyadmin. But I hope the import/export developer can fix this

Hi, I am not that familiar with phpmyadmin. I am having a look at it now. What section was it in, and any tips?

I have exported the reward file, but it doesn't like being imported.
Error
SQL query:

INSERT INTO `homebrew_opct2`.`Sheet1` (`product_reward_id`, `product_id`, `customer_group_id`, `points`) VALUES (1165, 49, 10, 7), (1166, 50, 10, 7), (1167, 51, 10, 7), (1168, 52, 10, 7), (1169, 53, 10, 7), (1170, 54, 10, 7), (1171, 55, 10, 7), (1172, 56, 10, 7), (1173, 57, 10, 7), (1174, 58, 10, 7), (1175, 59, 10, 7), (1176, 60, 10, 7), (1177, 61, 10, 7), (1178, 62, 10, 7), (1179, 63, 10, 7), (1180, 64, 10, 7), (1181, 65, 10, 7), (1182, 66, 10, 7), (1183, 67, 10, 7), (1184, 68, 10, 7), (1185, 69, 10, 9), (1186, 70, 10, 9), (1187, 71, 10, 9), (1188, 72, 10, 9), (1189, 73, 10, 11), (1190, 74, 10, 11), (1191, 75, 10, 11), (1192, 76, 10, 7.5), (1193, 77, 10, 7.5), (1194, 78, 10, 7.5), (1195, 79, 10, 7.5), (1196, 80, 10, 7.5), (1197, 81, 10, 7.5), (1198, 82, 10, 7.5), (1199, 83, 10, 7.5), (1200, 84, 10, 7.5), (1201, 85, 10, 7.5), (1202, 86, 10, 7.5), (1203, 87, 10, 11), (1204, 88, 10, 11), (1205, 89, 10, 11), (1206, 90, 10, 13.5), (1207, 91, 10, 11[...]

MySQL said:

#1054 - Unknown column 'product_reward_id' in 'field list'.
I have checked the box for the 1st column on & off.
I also tried using both existing data, as well as appending.

Did you export the file by using Phpmyadmin? I made an export in the OC built in "Backup/Restore", select only "product_reward".

This works for me to import by Phpmyadmin:

TRUNCATE TABLE `product_reward`; INSERT INTO `product_reward` (`product_reward_id`,`product_id`,`customer_group_id`,`points`) VALUES ('526','338','6','10');INSERT INTO `product_reward` (`product_reward_id`,`product_id`,`customer_group_id`,`points`) VALUES ('525','338','8','10');INSERT INTO `product_reward` (`product_reward_id`,`product_id`,`customer_group_id`,`points`) VALUES ('528','193','6','10');

Hi, thanks for replying. I was exporting using myphpadmin to *.xls, however I imported using *.csv.
I saw in another post (in hindsight), they recommended using a different program/format, rather than excel/word. The only issue I have is there are some other numbers (values), from when I was going thru the 4 different groups.