import json

with open('products.json') as f:
    j = json.loads(f.read())

counter = 0
with open('products.sql', 'w') as f:
    for i in j:
        if counter < 25:
            f.write('INSERT INTO `products` (`user_id`, `name`, `price`, `description`, `stock`, `weight`, `category`, `location`, `listed_timestamp`, `pending`, `archived`) VALUES (2, \'{}\', {}, \'{}\', 111, 222, 1, \'Sample location for product {}\', NOW(), false, false);\n'.format(i['name'].replace('\'', '\\\''), int(int(i['price']*1000) / 10), i['description'].replace('\'', '\'\''), counter))
        else:
            f.write('INSERT INTO `products` (`user_id`, `name`, `price`, `description`, `stock`, `weight`, `category`, `location`, `listed_timestamp`, `pending`, `archived`) VALUES (3, \'{}\', {}, \'{}\', 111, 222, 1, \'Sample location for product {}\', NOW(), false, false);\n'.format(i['name'].replace('\'', '\\\''), int(int(i['price']*1000) / 10), i['description'].replace('\'', '\'\''), counter))
        counter += 1