Postgres Range Type Support for Laravel 7

 The PosgreSQL range types package by @belamov provides range type support to Eloquent for the Postgres database:

 1Schema::create('table', function (Blueprint $table) {
 2    $table->id();
 3    // ...
 4    $table->dateRange('date_range');
 5    $table->timestampRange('timestamp_range');
 6    $table->floatRange('float_range');
 7    // for int4range
 8    $table->integerRange('integer_range');
 9    // for int8range
10    $table->bigIntegerRange('integer_range');
11 
12    // you can add any modifications
13    // $table->dateRange('date_range')->nullable();
14    // $table->dateRange('date_range')->default('[2010-01-01,2010-01-02)');
15});

The main features of this package include:

• Extended Laravel’s PostgresGrammar and PostgresConnection classes to provide a fluent API for range columns
• Support for the following Postgres range types: daterange, tsrange, numrange, intrange, and timerange.
• A number of query build macros for convenience (i.e., whereRangeContains($left, $right)
• Model property casting

The model property casting provided by this package provides convenience for working with ranges on model instances. For example:

1use Belamov\PostgresRange\Ranges\IntegerRange;
2 
3$range = new IntegerRange(10, 20, '[', ')');
4 
5$range->from(); // 10
6$range->to(); // 20
7(string) $range; // [10,20)
8$range->forSql(); // '[10,20)'

You can learn more about this package, get full installation instructions, and view the source code on GitHub at belamov/postgres-range. The package has an excellent blog post to bring you up to speed on the powerful features available in Postgres’ range types: Ranges in Laravel 7 using PostgreSQL.

Read More

 

How to Import Configurable Products in Magento 2

This guide will walk you through how to import configurable products in Magento 2 using CSV file.

Step 1: Prepare your CSV file

Go to your Magento Admin > System > Data Transfer > Import.

From the Entity Type drop-down selections, choose Products and make sure your File Format is CSV.

In Import Behavior, click and choose Add/Update.

After which, click on the Download sample file and you’ll receive a .CSV file containing the products whose SKUs you just put down.

Step 2: Complete the CSV file

Open your downloaded CSV file.

You’ll see that other fields in the CSV import file of configurable products are the same as the file of simple products. Yet, with configurable products, you’ll need to add some fields and follow the instructions:

1. List children products before configurable ones
2. Make sure the value in the ‘attribute_set_code’ column matches the name of the Attribute Set.
3. Add the ‘additional_attributes’ column and enumerate all the attribute set values for each child product. Put the attributes in the format as attribute_label=atrribute_value, separated by a comma.
4. Add the ‘configurable_variations’ column and fill in the set of SKU and Option (only for the parent products). Put the products in the format as SKU = child_sku, attribute_label=attribute_value, separate by ‘|”. The value attribute must correspond to the product value.
5. Add and check the correlation between the Attribute Code and the Label name in the ‘configurable_variation_labels’ column (only for the parent products). Here you’ll declare an attribute in the format as attribute_code=attribute_label, separated by a comma.

Step 3: Import CSV file

Go back to your Magento backend, go to System > Data Transfer > Import.

Then go to File to Import > Select File to Import. Select the file you want to import into your Magento store system.

And click on Check Data on the right corner.

You can leave other fields as they already are by default.

After the data checking process completes, you can proceed to import if the checking result is valid, else you need to edit your CSV file until it is free of error.

Click Import to start the import process. When everything’s done you will receive the below success message.

Now you can go to your frontend to check the result.

Read More