Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1040143, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1050145, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1070014, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1070015, 10000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1050112, 10000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1060123, 10000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1060125, 10000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1060122, 10000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1040141, 10000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1041146, 10000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1051169, 10000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1071024, 10000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1071025, 10000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1041126, 10000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1051113, 10000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1061139, 10000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1234, 1061147, 10000000, 17);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1234,9201023 );
Here's your 2 sqls put together, and I changed the NPC to Nana(K) in Kerning City.
You also had a duplicate of an item in your sql, the Pink Miniskirt. Removed the second one.