Ini adalah Joomla Components pertama yang saya buat, karena permintaan klien untuk menginput data ke dalam Virtuemart component. Jujur harus saya akui bahwa saya adalah orang yang malas untuk menginput data. Mungkin tidak jadi masalah jika data yang diinput hanya 20-30, tetapi akan menjadi masalah besar jika data yang harus diinput berjumlah ratusan atau ribuan items. Dapat saya bayangkan jika saya menginput satu per satu, pasti terdapat banyak kesalahan karena human error :)
Sebenarnya bukan ide saya untuk membuat komponen ini, saya hanya melanjutkan pekerjaan teman saya. Menyederhanakan kode, menambahkan fasilitas dan konfigurasi, serta meningkatkan kemampuan kode sehingga terciptalah Virtuemart CSV UploaderActually, this is not my idea, I just continue the work of my friend. Adding facilities, summarize, improve the code and so on, so as Component. Sesuai namanya, komponen ini hanya bekerja di backend Joomla dan tidak diperlukan di frontend Joomla.
Dengan component ini, data CSV beserta gambar dikompresi menjadi file zip yang selanjutnya diupload melalui form sederhana yang telah tersedia (lihat gambar diatas), lalu tekan tombol "Upload Zip File". Lalu... data beserta gambar akan teratur dengan rapi ke dalam database Virtuemart. Kehandalan dalam kesederhanaan :)
CSV Info
- CATEGORY *: Product Category.
- SUB-CATEGORY: Product Sub-category (if any).
- SKU *: Product stock keeping unit (SKU), must unique code.
- PRODUCT ID: Parent SKU, must unique code, alpha-numeric only. Required if STATE is not 0 (null). Parent and child products have same PRODUCT ID.
- STATE *: 0 = single product (no parent, no child). 1 = parent product. 2 = child product.
- PUBLISH *: 0 = unpublished. 1 = published.
- TITLE *: Product title.
- PARENT TITLE: Parent product title. Required if STATE is not 0 (null). Parent and child products have same PARENT TITLE.
- VARIAN: Product attribute. Required if STATE is not 0 (null). Every attributes (if multiple) separated by vertical bar (|). Attribute name and attribute value separated by colon (:)
Example 1 (single attribute): "Color:Red" (without quote)
Example 2 (multiple attribute): "Color:Red|Size:Big" (without quote) - WEIGHT: Unit of measure, numeric only. Required for product which use shipping option.
- LENGTH: Unit of measure, numeric only.
- WIDTH: Unit of measure, numeric only.
- HEIGHT: Unit of measure, numeric only.
- BASE PRICE *: Price without additional surcharge (tax, packing, handling etc).
- SHORT DESCRIPTION: Product short description. Required if STATE is not 2 (two). 255 character max.
- DESCRIPTION: Product description. Required if STATE is not 2 (two).
- RELATED PRODUCT: Related product SKU, separated by vertical bar (|).
- QUANTITY: Product in stock, numeric only.
Configuration
- Image Size: big image size, width x height (in pixel).
- Thumbnail Size: thumbnail image size, width x height (in pixel).
- Image Location: product images location, please check your virtuemart configuration.
- Currency Code: 3 character currency code, all capital.
- Weight UOM: weight unit of measure (grams, kilograms, pound).
- LWH UOM: length, width & height unit of measure (mm, cm, inch).
- Tax Rate ID: product tax ID, please check your virtuemart tax rate setting.
- Product Unit: piece, box, etc.
- Child Option: select 'One Add to Cart Button' or 'Add to Cart Button for each Child'.
- Category Browse Page: please check your virtuemart product category setting.
- Category Flypage: please check your virtuemart product category setting.
- Products per Row: show x products per row.
Mohon dipahami bahwa CSV adalah singkatan dari Comma-Separated Values, yang berarti pemenggalan data values berdasarkan keberadaan comma. Untuk itu, anda tidak diperbolehkan menggunakan comma dalam data fields atau data menjadi berantakan. More CSV Information
Download sample data! Are you interested with Virtuemart CSV Uploader component? Please contact us.
