Big Cartel
Big Cartel
7/10
Rate it
What is Big Cartel?
Big Cartel is web-based, fully hosted software, sporting simplicity of design and ease of use with zero transaction fees. Functions are simple, and the process of adding products, creating discounts, and managing orders and inventory is as smooth as it gets. Unfortunately, that ease of use comes with a limited feature set. If you’re selling mass quantities, Big Cartel likely won’t be able to fill your needs. However, if you’re just starting out or you don’t need a whole lot of advanced features, Big Cartel might be just the ticket.
Tags

Tips

Create / Open / Delete Database
CREATE DATABASE dbNameYouWant
CREATE DATABASE dbNameYouWant CHARACTER SET utf8
USE dbNameYouWant
DROP DATABASE dbNameYouWant
ALTER DATABASE dbNameYouWant CHARACTER SET utf8
Update
UPDATE table1 SET field1=new_value1 WHERE condition
UPDATE table1, table2 SET field1=new_value1, field2=new_value2, ... WHERE table1.id1 = table2.id2 AND condition
Insert
INSERT INTO table1 (field1, field2, ...) VALUES (value1, value2, ...)
Conditions
field1 = value1
field1 <> value1
field1 LIKE 'value _ %'
field1 IS NULL
field1 IS NOT NULL
field1 IS IN (value1, value2)
field1 IS NOT IN (value1, value2)
condition1 AND condition2
condition1 OR condition2